Identifying the # of cells containing data

  • Thread starter Thread starter WA
  • Start date Start date
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.
 
=countif(a1:a10,">"&0)
(which is equivalent to)
=countif(a1:a10,">0")


or if you put the 0 in X99:
=countif(a1:a10,">"&x99)
 
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...
 
Back
Top