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.

Hi,
Try

=COUNTIF(K1:K25,"0")

Change the range to fit your needs

"WA" wrote:

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)

WA wrote:

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.

--

Dave Peterson