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 wrote:

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