adding letters

Post Reply
chnshz
Posts: 1
Joined: Sun Dec 26, 2021 7:25 pm

adding letters

Post by 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
SoftMaker Team
SoftMaker Team
Posts: 2935
Joined: Wed Mar 11, 2020 5:31 pm

Re: adding letters

Post by 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.
Post Reply

Return to “FreeOffice PlanMaker 2021 for Windows”