Len Function for Multiple Cells

Question

need a character count function like the len function but I need it to take a range (i.e A1:D22). What do you suggest I use? I'm looking for something other than fill down on the len function across multiple columns and rows and then sum it all. I'm trying to do it with one function. This is to use it as a check value.

Solution 1

If I understand well, you can use the following array formula:

=SUM(LEN(A1:D22))

Note: press CTRL+SHIFT+ENTER to enter the formula (because this is array formula)

Solution 2

You can use an array formula

=SUM(LEN(A1:D22))

Enter and hit control + shift + Enter