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?