sum of characters
 

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.

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!

In article ,
ddwchs wrote:

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.

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)


"ddwchs" wrote in message
...
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.

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

see: http://www.mvps.org/dmcritchie/excel...htm#countchars

regards,
hector.