Help Needed With Count
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. |
Quote:
|
Help Needed With Count
On Monday, September 3, 2012 9:37:41 PM UTC-4, trvlnmny wrote:
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. |
1 Attachment(s)
Quote:
This counts each and every instance of a given character, even if there are more than one in a cell. Or did you mean count the number of cells a given character appears in despite how many times in each? |
Help Needed With Count
Hi,
Am Tue, 4 Sep 2012 06:14:55 -0700 (PDT) schrieb : Yes the character may appear more than once in a cell. try: =COUNTIF(B4:C25,"*&*") Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
All times are GMT +1. The time now is 08:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com