Sumproduct

[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

 

[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

 

[T De Villiers]

Works a treat, thanks a treat Roger