Help: Formula that displays a number based on how many cells in a column have text?

[Peaceful Jim]

Hey guys,

I've used Excel for many years now, but have only recently needed to begin using formulas. Please forgive me if my question doesn't make sense!

I will admit, I am under a bit of pressure, so I am looking for a quick answer, which is why I didn't go delving very far into instruction manuals and the like.

I am part of a clan in an online game, and we have an Excel sheet with our current list of clan members. What I need is a formula that will show a number based on how many cells in a column have text in them.

For example, we have column A with only names in them. If we had 15 cells with names in them, i'd like this formula to show '15'. I do hope that makes sense!

Thank you for your assistance.

Kind regards,

Peaceful Jim.

[sandy666]

=COUNTA(your_range) if there is no numbers (counting non-blank cells)
or
=COUNTIF(your_range,"*") which count text values

[guru008]

Hi,

CountA() is used to count text values in a column, you should use CountA() in this case

[sandy666]

Hi,

CountA() is used to count text values in a column, you should use CountA() in this case

Really??? Are you sure?

[Peaceful Jim]

Thank you, sandy666, this worked perfectly! You are a legend!

[sandy666]

Hehehe, I know Jim
Thanks for rep and marking thread solved.smile3_e0.gif