Sum column using 2 other columns as criteria

H

Hall

My table has 3 columns: A, B, and C. C has all numeric values.

I want to SUM values in C for all rows where value in A equals "a" and value
in B equals "b".

Can anyone tell me a formula construct for this?

Thanks!
 
T

Trevor Shuttleworth

=SUMPRODUCT((A1:A14="a")*(B1:B14="b")*(C1:C14))

Adjust the range as required

Regards

Trevor
 
Top