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: 4910

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

Go to advanced search