Len Function for Multiple Cells

excel, excel-formula

Solution

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)

Problem

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.

Original source