I have to create a function that counts and shows in one cellm the times that the "s" character appears in a row range in Excel. It has to be robust enough since many times the "s" character can appear with hundreds of combinations, so doing =COUNTIFS(C4:AG4;"s";C4:AG4;"sc"...)
wouldn't work.
I decided to write =LEN(C3)-LEN(SUBSTITUTE(C3;"s";""))
and it is robust enough to only count the times that s is said in each cell. I could simply copy paste that function and change the argument to D4,F4,G4,H4... and do a summation of it all, but I think it is not an elegant solution. Anyone has a better idea?