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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks