In Excel can you add cell A2:A10 that only have text

[Max Toro]

I'm trying to find the total cell count in Excel, please help.

 

[Ron Coderre]

If you want to count the number of TEXT cells in a range, try this:

=COUNTA(A1:A10)-COUNT(A1:A10)
That subtracts the count of numeric entries from the count of non-blank cells.

Does that help?

••••••••••
Regards,
Ron

 

[Max Toro]

That's it. I gladly appreciate the help Ron.

Best Regards,
Max