I'm trying to count columns in a second worksheet. 1) If column A is = apple,
then I want to count the entries in column B which are greater than "0"
sheet 2
apple 2
apple 10
apple 0
apple 3
pear 2
pear 0
pear 5
overall the count for apple would be 3. If I do the same thing for pear it
would be 2.
Thanks for your help