counting and excluding a value

[Debbie]

Hi, I need a formula that will count a range of values but
exclude where the cell has a .00
For ex:
12.50
4.20
..00
..00
1.50
Result will be 3
Thanks in advance.
Debbie

 

[Dave R.]

Note that this looks for 0, but wouldn't work for 0.000000000002, which
might appear as 0.00 on your sheet.

=SUMPRODUCT((ISNUMBER(A1:A25)*(A1:A25<>0)))

 

[JE McGimpsey]

One way:

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