Search found 1 match

Go to advanced search

by chnshz
Sun Dec 26, 2021 7:34 pm
Forum: FreeOffice PlanMaker 2021 for Windows
Topic: adding letters
Replies: 1
Views: 26727

adding letters

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 ...

Go to advanced search