Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

Count total characters in a range

How to Count Total Characters in a Range

To count total characters in a range can be challenging particularly while dealing with large data. However, with MS Excel, you can make the counting pretty easy. You just apply is a formula that uses SUMPRODUCT AND LEN functions.  Here’s how the formula looks.

Generic Formula

=SUMPRODUCT (LEN(rng)

…..where “rng” is the cell of interest while “LEN” is the formula that will count the characters before the total summations are carried out.

Example

We have got cells in the example that contain text. We want to get the count of total characters in a range using the formula discussed above. Check how we’ve done it:

Figure 1. Example 1 of SUMPRODUCT/ LEN Function

The formula of the in the highlights cell (C11) is:

=SUMPRODUCT(LEN(B5:B9))

How does the Formula Work

LEN is the first function to be evaluated. It calculates all characters in each of the five cell i.e. between B5 and B9. The calculation includes space characters in all cell. The result from LEN will, therefore, be an array of 5 numbers. The SUMPRODUCT then adds or sums up the five numbers in the array to return the final total. That is how a total of 98 is realized.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Solution examples
wondering if there is a formula that when the name in one cell changes, the formula in the other cell changes? for example: working on a calculating cost for harvesting grain crops based on acres, bushels harvested, and bushels harvested over x/bushels per acre. in cell B3 i want when cell A1 says "wheat harvest" it will subtract 20 from cell B2, but when cell A1 says "corn harvest" i want to subtract 40 from cell B2 is this possible? thanks
Solved by T. D. in 20 mins
Help, I need a formula to measure if date entered in column e, is between date in column a and date in column b. please
Solved by V. U. in 20 mins
Adding criteria to If(And( ),Sumproducts()
Solved by G. U. in 19 mins
I need section of text deleted in a column . Problem is the cell in each column Is html and seems it will be a challenge but if you can do this , you are genius
Solved by B. A. in 60 mins
How do I prevent Duplicate entries in multiple columns in Excel using data validation in MSExcel 2016. I would like to prevent the user from data entering a code more than once in three column ranges
Solved by B. D. in 60 mins

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc