adding letters

[chnshz]

I want to to count total letters in a cell and add total letters in different cells.

Expample:

cell a1: "wwljkyw" has 3 "w"s
cell a2: "ww456www" has 5 "w"s

for a total of 8 "w"s.

Google sheets has the formula
=ARRAY_CONSTRAIN(ARRAYFORMULA(SUM(IF(LEN(B3:B100)-LEN(SUBSTITUTE(B3:B100,"w",""))>0,LEN(B3:B100)-LEN(SUBSTITUTE(B3:B100,"w","")),0))), 1, 1)

But I can't make it work anywhere else.

I would continue using Google sheets but connection issues have been a problem lately and I want to have access offline.

Thank you.

[SuperTech]

There is a simple formula

Code: Select all

=LEN(A1)-LEN(SUBSTITUTE(A1,"w",""))

, this will give you the total count of "w" in the cell A1, similarly you can count for A2 and then total them.