Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove last three characters of cell | Excel Discussion (Misc queries) | |||
Help! Can't get rid of hidden characters | Excel Discussion (Misc queries) | |||
Problem with counting characters in a cell | Excel Worksheet Functions | |||
Deleting Blank Characters in a Cell | Excel Discussion (Misc queries) | |||
Deleting 3 Text characters from the right | Excel Worksheet Functions |