Excel Count Formula?

[Mrebisz3154]

Hi - How do I write a count formula for non-blank cells that may contain
either a "X" or a number?

[Ron Coderre]

See if the COUNTA function returns what you are looking for.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Mrebisz3154" wrote:

> Hi - How do I write a count formula for non-blank cells that may contain
> either a "X" or a number?

[SteveG]

=COUNTIF(A1:A30,"x")+COUNTIF(A1:A30,">=0")

This is assuming you want to count cells that contain a 0, if you don't, just remove the = from the second COUNTIF.


HTH

Steve