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