Count Total Number of Characters in Column – Excel & Google Sheets
Download Example Workbook
Download the example workbook
This tutorial will demonstrate how to count the total number of characters in a column in Excel and Google Sheets.
SUMPRODUCT and LEN Functions
To count the total number of characters in a column we can use the SUMPRODUCT and LEN Functions.
First, we can use the LEN function can be used to give us the length of the text in the cell range selected.
Next, we can use the SUMPRODUCT Function to show the number of characters in the column as a total.
Count Total Number of Characters in Column in Google Sheets
The example above works the same way in google sheets.