Countif a corresponding value is not equal to zero or blank

R

raphiel2063

I want to use countif to count the number of entries in a big list. However,
I want to count the number of times an entry appears but only if the column
next to it is not equal to zero of blank.

E.g.
Qty
Apple 1
Banana 0
Apple 0
Apple 6
Banana 3

I would like to be able to use countif to sum up the number of times apple
appears when the qty is greater than zero (or blank) so in this case it would
be 2, not 3 as one entry is 0.

Can you help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif a set of corresponding values 1
COUNTIF Multiple Values 3
COUNTIF text where there is more than one word in a cell 2
Count values from Pivot Table 11
COUNTIF for 2 columns 6
Count with two criteria in a second worksheet 1
Countif and values greater than zero for a named range 1
COUNT IF NOT EQUAL TO ZERO 12

Top