View Single Post
  #2   Report Post  
Old December 12th 04, 09:00 PM
JE McGimpsey
 
Posts: n/a
Default

One way, array-entered (CTRL-SHIFT-ENTER or CMD-RETURN):

Assuming your range is named rng,

=SUM(LEN(rng)-LEN(SUBSTITUTE(rng,",","")))

In article ,
Brenda wrote:

I need to count the occurence of a character (i.e. a comma (,)) in a range of
cells. Each comma represents a value of one and may occur more than once in a
cell. Then I need to have the total sum of commas found. Thanks in advance.
Brenda.