=Countif(A2:A500,"*") not giving accurate count

[Noir]

This formula is simple enough yet, i have never been able to figure out why it "sometimes" gives an incorrect reading (eg:lines A2:A49 filled with data but, formula returns count of 46).

Any ideas why this is?

Thx,
Noir

 

[stevebausch]

You may need to Trim() your data, perhaps uCase() it, etc.

I don't exactly know what you are searching for, since the board's page code generator may have mangled your post.

 

[Aladin Akyurek]

On 2002-08-21 08:13, Noir wrote:
This formula is simple enough yet, i have never been able to figure out why it "sometimes" gives an incorrect reading (eg:lines A2:A49 filled with data but, formula returns count of 46).

Any ideas why this is?

Thx,
Noir

=COUNTIF(Reference,"*")

does not count numbers in Reference when their underlying format is number.

What kind of data do you have in A2:A49?

And, did you try COUNTA or COUNT?

 

[Noir]

Yes, the board did mangle the post but, i am looking for any within A2:A500 or "*". Just can't figure out why it gives wrong counts.

 

[Noir]

No, i did not try COUNTA or COUNT but, i will. I have alpha-numeric serial numbers listed in A2:A500.

Noir

 

[Mark W.]

Use...

=COUNTIF(A2:A500,"<>")

 

[Noir]

Mark, your formula worked perfectly.

Thx,
Noir