I'm struggling to find a formula that will help me calucate the following:-
A B
1 Apple 7
2 Pear 0
3 Orange 4
4 Apple 2
5 Pear 1
6 Orange 0
What I want it to do is look down column A for all the Pears, and tell me the Count in Column B if the cell value is greater than 0.
For example for:
Pears the answer would be 1
Apples the answer would be 2
Oranges the answer would be 1.
I know for some this is probably dead easy but I'm getting really frustrated !
Many thanks - Emma![]()
Bookmarks