如何取数问题

等爱

=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),"")
三键结束