|
楼主 |
发表于 2022-1-31 10:21
|
显示全部楼层
你好,老师,想问一下=INDEX($C$9:$C$18,MATCH(MAX(SUMIFS($D$9:$D$18,$A$9:$A$18,F19,$B$9:$B$18,G19,$C$9:$C$18,$C$9:$C$18)),SUMIFS($D$9:$D$18,$A$9:$A$18,F19,$B$9:$B$18,G19,$C$9:$C$18,$C$9:$C$18),))
其中 SUMIFS函数最后两个参数“$C$9:$C$C18:$C$9:$C$C18”,是表示符合前面两个条件的各组别合计金额分别是多少吗?这个是涉及到数组所以要加ctrl+shift+回车吗?如果最后两个参数不这样写,可不可以写成:MAX(SUMIFS($D$9:$D$18,$A$9:$A$18,F19,$B$9:$B$18,G19,$C$9:$C$18,“GL1”),SUMIFS($D$9:$D$18,$A$9:$A$18,F19,$B$9:$B$18,G19,$C$9:$C$18,“GL3”),SUMIFS($D$9:$D$18,$A$9:$A$18,F19,$B$9:$B$18,G19,$C$9:$C$18,“FA”)) 这样子啊? ,谢谢
|
|