Sumproduct
 

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


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=472901

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

Works a treat, thanks a treat Roger


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=472901