Count no. of occurences without counting ZEROES

[hsandeep]

I am counting 'no. of values' by using formula =COUNTIF(C59:C162,"?*")+COUNT(C59:C162).
But it also counts 0 (zero). I want that it should not count 0s occurred in cells.
How to accomplish?

 

[T. Valko]

I tried. I need something like IFZERO(vlookup,""). Please help

If your VLOOKUP normally returns a text value try it like this:

=T(VLOOKUP(...))

 

[Aladin Akyurek]

NO. It is still counting 0 occurences in the cells. These 0s are generated through vlookup formulas.

Care to post the VLOOKUP formula?

 

[Nakes]

Do a vlookup to pull the values
Ensure all you vlookup formula results are formatted as numbers
Use COUNT(RANGE)-COUNTIF(RANGE,0)

That should work.