Hi,
Try this with array formulas (Ctrl+Shift+Enter):
SUM(IF((A5:A7="03")*(B5:B7="A"),C5:C7))
Regards,
Ashish Mathur
"GateKeeper" wrote:
I have a table like this:
Column_A Column_B Column_C
03 S 100
03 T 100
02 S 100
02 T 100
04 S 100
04 T 100
I want to sum the cells in C only when A="03" and B="S". In this case, I
would expect the total to be 100.
|