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

LEN Function

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

SUMPRODUCT Function

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

Count Total Number of Characters in Column in Google Sheets

The example above works the same way in google sheets.

count total characters column Google Function