ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I need to count the occurence of text in a range of cells (which . (https://www.excelbanter.com/excel-worksheet-functions/7828-i-need-count-occurence-text-range-cells.html)

Brenda December 12th 04 08:13 PM

I need to count the occurence of text in a range of cells (which .
 
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.

JE McGimpsey December 12th 04 09:00 PM

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.



All times are GMT +1. The time now is 05:36 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com