#1   Report Post  
ddwchs
 
Posts: n/a
Default 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   Report Post  
Domenic
 
Posts: n/a
Default

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   Report Post  
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Héctor Miguel
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
remove last three characters of cell mira Excel Discussion (Misc queries) 8 July 28th 05 12:06 AM
Help! Can't get rid of hidden characters tragopanic Excel Discussion (Misc queries) 1 July 13th 05 10:20 PM
Problem with counting characters in a cell Tink Excel Worksheet Functions 2 June 27th 05 12:52 PM
Deleting Blank Characters in a Cell PokerZan Excel Discussion (Misc queries) 4 June 3rd 05 09:43 PM
Deleting 3 Text characters from the right Helen Excel Worksheet Functions 7 April 26th 05 04:17 PM


All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"