Hi All,
Wondering if you can help me, I have a table like the below:
Area Fruit
NW Apples
NW Apples
SS Pear
NE Apples
SS Orange
JP Grape
I have two fields like the below:
Area Fruit
NW Apples
I want to know the number of Apples in NW for example, when I use the formula below:
=(SUMPRODUCT((Data!C:C=A2)*(Data!F:F=B2))), I get 2, my issue is, when I remove apples from the fruit field above and just want to see the number of fruits in NW, I get 0 or 1. How do I go about this issue where if a fruit field is empty, just return the result for the area?
If this makes sense.
Thank you
Bookmarks