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