Identifying the # of cells containing data

[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.

 

[Eduardo]

Hi,
Try

=COUNTIF(K1:K25,">0")

Change the range to fit your needs

 

[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)

 

[WA]

Great - thanks for your assistance guys.

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


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