Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 4th 12, 02:37 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 23
Default 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.

  #2   Report Post  
Old September 4th 12, 07:49 AM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by trvlnmny View Post
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?
  #3   Report Post  
Old September 4th 12, 02:14 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2012
Posts: 13
Default 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.
  #4   Report Post  
Old September 4th 12, 02:58 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by View Post
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.
Have a look at the attached. Is this what you mean?

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?
Attached Files
File Type: zip Excel Example - Character Frequency Count.zip (7.8 KB, 48 views)
  #5   Report Post  
Old September 4th 12, 03:48 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,729
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula needed to SUM and COUNT in specific way K[_2_] Excel Programming 1 February 23rd 10 12:26 PM
Count if ? formula needed! katagrga Excel Discussion (Misc queries) 3 June 24th 09 04:26 AM
More Help Needed with Count formula Greegan Excel Worksheet Functions 4 July 31st 05 06:31 PM
Count duplicates needed WylieC Excel Programming 3 January 15th 04 07:46 AM
A count function or macro needed dkenebre Excel Programming 2 November 15th 03 07:00 PM


All times are GMT +1. The time now is 05:44 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017