Sum

G

Guest

Is there a way i can count the number of cells in a particular column that
have text? Right now, for example, I have B4 - B32 that have a name in them,
what i was trying to do is sum that up on B33 so the value in B33 would be x
number of cells that have text...if that makes any sense
 
C

Chip Pearson

The COUNTA function will give you the number of cells that are
either numbers or character text.

=COUNTA(A1:A10)

If you want to count only those cells with character text, and
not count numbers, use

=COUNTA(A1:A10)-COUNT(A1:A10)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum 2
SUM (TODAY thru EOM) 6
How to force a cell value to change if Linked cell moves? 2
Formula Cell color limitation 7
Summing a range that changes 6
Help to create biweekly dates excluding nonworking days 2
Formula error? 2
Cell Referencing 2

Top