如何取数问题

九界

=SUMIFS($C$2:$C$33,$A$2:$A$33,$F2,$B$2:$B$33,G$1)
0值显示空的话
=IFERROR(1/SUMIFS($C$2:$C$33,$A$2:$A$33,$F2,$B$2:$B$33,G$1)^-1,"")

老国

=sumifs(c:c,a:a,$f2,b:b,g$1)

很乐观的小伙

G2
右拉下拉
=SUMIFS($C:$C,$A:$A,$F2,$B:$B,G$1)

方大人

这不就是求和嘛？
=SUMIFS($C:$C,$A:$A,$F2,$B:$B,G$1)

来自潘多拉星球的猪

=IFERROR(LOOKUP(1,0/((G$1=$B$2:$B$33)*($F2=$A$2:$A$33)),$C$2:$C$33),"") 横拉下拉

老松

=IF(COUNTIFS($A:$A,$F2,$B:$B,G$1),SUMIFS($C:$C,$A:$A,$F2,$B:$B,G$1),"")

蓝色眼睛

=SUMPRODUCT(($B$2:$B$33=G$1)*($A$2:$A$33=$F2)*$C$2:$C$33)

丁日南

这样？
=IFERROR(VLOOKUP($F2&G$1,CHOOSE({1,2},$A$2:$A$33&$B$2:$B$33,$C$2:$C$33),2,0),"")
三键结束

钱晓东

这不就是求和嘛？
=SUMIFS($C:$C,$A:$A,$F2,$B:$B,G$1)

友泉

=IFERROR(LOOKUP(1,0/((G$1=$B$2:$B$33)*($F2=$A$2:$A$33)),$C$2:$C$33),"") 横拉下拉