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.