Posted to microsoft.public.excel.worksheet.functions

Arnold R

external usenet poster

Posts: 5

Counting function

"Gary" wrote:

=COUNTIF(A1:A10,"N")

Assuming the data range is A1 to A10. You can change it as per the
requirement.

"Arnold R" wrote in message
...
I have a column of data that contains either the letter n or the letter y.
How can I count the number of cells that contain the letter n? I would
have
thought this would be done with the COUNTA function but I can't see how.
Thanks for any help.

Thanks very much for your help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Counting Function	Amber	Excel Worksheet Functions	9	May 15th 07 09:28 PM
Counting Function	Mythran	Excel Worksheet Functions	5	March 24th 06 07:45 PM
Counting Function	MAB	Excel Worksheet Functions	10	January 25th 06 04:53 PM
Letter Counting Function	bctrophy	Excel Worksheet Functions	2	December 21st 05 10:36 PM
A Function for Counting Since Last Time	[email protected]	Excel Worksheet Functions	1	June 9th 05 07:31 PM

All times are GMT +1. The time now is 08:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us