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

[T De Villiers]

Works a treat, thanks a treat Roger