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.

count total characters column Main Function

SUMPRODUCT and LEN Functions

To count the total number of characters in a column we can use the SUMPRODUCT and LEN Functions.

=SUMPRODUCT(LEN(B3:B5))

count total characters column 01

First, we can use the LEN function can be used to give us the length of the text in the cell range selected.

=LEN(B3:B3)

count total characters column LEN

Next, we can use the SUMPRODUCT Function to show the number of characters in the column as a total.

=SUMPRODUCT(LEN(B3:B5))

count total characters column 01

The example above works the same way in google sheets.

count total characters column Google Function