sum of characters

D

ddwchs

What is the formula for finding the total number of letters in a range of
cells? Example - How many x's and how many t,s in cels A1:G1.
 
D

Domenic

For the number of x's...

=COUNTIF(A1:G1,"x")

For the number of x's and t's...

=SUMPRODUCT(--(ISNUMBER(MATCH(A1:G1,{"x","t"},0))))

Hope this helps!
 
B

Bob Phillips

If each cell can have more than one x, and/or other characters, then try

=SUMPRODUCT(--(LEN(A1:G1)-LEN(SUBSTITUTE(UPPER(A1:G1),"X",""))))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top