Excel 2003 - Counting Zeros

[Craig Brandt]

Is there an easy way to count zeros in a contigous string of cells.
I tried count and counta, but they treat zeros as numbers.
Thanks,
Craig

 

[PCLIVE]

Have you tried COUNTIF?

=COUNTIF(A1:A10,0)

HTH,
Paul

 

[Pete_UK]

Use COUNTIF, like this:

=COUNTIF(range,0)

Hope this helps.

Pete

 

[Craig Brandt]

Thank you, Paul.

Worked like a champ.

Craig

Have you tried COUNTIF?

=COUNTIF(A1:A10,0)

HTH,
Paul

 

[PCLIVE]

Glad to help.

--

Thank you, Paul.

Worked like a champ.

Craig