Identifying the # of cells containing data

W

WA

Hello,

I have a worksheet with a column that contains 10 vlookup functions (1 in
each row). In each cell, the vlookup function displays either a zero, or a
number greater then zero. Is there a function that will return the number of
cells containing a value greater then zero?

The 'count' function does not work. Because there are values in all cells,
it returns the number ten.

Thanks.
 
D

Dave Peterson

=countif(a1:a10,">"&0)
(which is equivalent to)
=countif(a1:a10,">0")


or if you put the 0 in X99:
=countif(a1:a10,">"&x99)
 
W

WA

Great - thanks for your assistance guys.

Dave Peterson said:
=countif(a1:a10,">"&0)
(which is equivalent to)
=countif(a1:a10,">0")


or if you put the 0 in X99:
=countif(a1:a10,">"&x99)
Click to expand...
 

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

Display results of formula 1
count the number of rows with entries greater than zero 1
VLOOKUP worksheet function returns zero for empty cells 3
Divide by the minimum non-zero number in a range of cells 21
SUMIF using value from MOD function 2
Countif and values greater than zero for a named range 1
Excel Use COUNTIF across a range of cells with formulas 0
text if negative value 2

Top