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
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.