COUNT Problem

[dknowles2004]

Hi

I want to count a range of values in Excel (not VBA) so that:

1. If value = 0 then disregard
2. If value = any other value then count count 1 for each instance

For example,
A1 = 0
A2 = 0
A3 = NISS
A4 = FDIA

Count value is therefore 2.

 

[fairwinds]

Hi,

Try:

=COUNTIF(A1:A10,"<>0")

 

[Juan Pablo González]

=COUNTIF(YourRange, "<>0")

or

=COUNTA(YourRange) - COUNTIF(YourRange, 0)