Sumproduct

T

T De Villiers

Hi,
Got the following data


1
2
3 w 2
3 w 5



=SUMPRODUCT((A12:A15="3")*(B12:B15="w")*(C12:C15))


This should give me 7 but gives me 0, there is something
wrong with the formula, any help is much appreciated

Thks
 
R

Roger Govier

Hi

Take the quotes away from the "3", assuming the 3 is a number and not a
text value.

=SUMPRODUCT((A12:A15=3)*(B12:B15="w")*(C12:C15))


Regards

Roger Govier
 
Top