sumif2

[Guest]

I've got it like this
A B C
30 2 JNB
11 3 CPT
10 4 RIO
11 5 JNB
13 6 JNB
10 7 CPT
And what I need are the total out of B only if A=11 and C=CPT.
I've had a previous one that worked the figures from B but it seems that I
must have this condition in as well.

Thanks

 

[Guest]

=sumproduct(--(A1:A10=11),--(c1:c10= "CPT"),B1:B10)