Counting text cells 1

[Mizzness]

All.

Is there a formula to count only the numeric cells in a range ?

e.g.:
A1 = 123
A2 = 456
A3 = HELP
A4 = 789
A5 = LUCK

The formula would give me 3 as the answer.

Thanx.

 

[AnotherHiggins]

COUNT only counts numberic cells. COUNTA counts text and numberic cells

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[Mizzness]

John,

Yes COUNTA will give me 5 as an answer but am I to believe that no formula can accomplish this ?
Remember, I'm looking to count only the numeric values.

Thanx.

 

[AnotherHiggins]

Read my first sentence again. =COUNT(A:A) only counts numbers.

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[bluedragon2]

Reread John's post. COUNT will do what you want.

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Mizzness]

<sheepishly walking away>

Thanx John.
In haste I did not read it through as Blue stated.

Thanx again.

 

[AnotherHiggins]

No problem. Glad to help.


[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.