Help Needed With Count

[trvlnmny]

I want to count the number of times a specific character appears in a
range of cells.
Lets say B4:C25.
The character can be an alpha, number or a symbol.
The character may or may not be in the cells.
If the character is present in a cell it may or may not be the only
character in the cell.
If the character is present in a cell, with other characters, it may
be positioned anywhere in the cell.
In English what I want is a count of the number of cells that contain
the & character in the range of cell B4 to C25.

 

[Spencer101]

I want to count the number of times a specific character appears in a
range of cells.
Lets say B4:C25.
The character can be an alpha, number or a symbol.
The character may or may not be in the cells.
If the character is present in a cell it may or may not be the only
character in the cell.
If the character is present in a cell, with other characters, it may
be positioned anywhere in the cell.
In English what I want is a count of the number of cells that contain
the & character in the range of cell B4 to C25.

Hi, could the & appear more than once in any given cell? And if so
would you count that as 1 or number of times it appears

 

[trvlnmny]

I want to count the number of times a specific character appears in a

range of cells.

Lets say B4:C25.

The character can be an alpha, number or a symbol.

The character may or may not be in the cells.

If the character is present in a cell it may or may not be the only

character in the cell.

If the character is present in a cell, with other characters, it may

be positioned anywhere in the cell.

In English what I want is a count of the number of cells that contain

the & character in the range of cell B4 to C25.

Spencer,
Thanks for your reply.
Yes the character may appear more than once in a cell.

 

[Spencer101]

Spencer,
Thanks for your reply.
Yes the character may appear more than once in a cell.

Have a look at the attached. Is this what you mean?

This counts each and every instance of a given character, even if ther
are more than one in a cell.

Or did you mean count the number of cells a given character appears i
despite how many times in each

+-------------------------------------------------------------------
|Filename: Excel Example - Character Frequency Count.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=566
+-------------------------------------------------------------------

 

[Claus Busch]

Hi,

Am Tue, 4 Sep 2012 06:14:55 -0700 (PDT) schrieb (e-mail address removed):

Yes the character may appear more than once in a cell.

try:
=COUNTIF(B4:C25,"*&*")


Regards
Claus Busch