Posted to microsoft.public.excel.worksheet.functions

Christopher Naveen[_2_] Christopher Naveen[_2_] is offline

external usenet poster

Posts: 58

Countif Function

Hi

I have a data as mentioned below can u pls tell me how can we count a
particular No. in a column.

Ex : 658
657
658
666
658

Now I want to count how many 658's and how many 666's are ther in the column.

Ans : 658 = 3
666 = 1

Can anyone help me how can we apply the formula to get the result.

Thanks in Advance!!!!

-Christ

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
COUNTIF Function	mpenkala	Excel Worksheet Functions	2	January 4th 07 04:25 PM
please help how to combine IF function with Countif function	Dinesh	Excel Worksheet Functions	6	March 30th 06 08:28 PM
countif function	a haigh	Excel Discussion (Misc queries)	3	March 28th 06 01:24 PM
How do I use a countif function according to two other countif fu.	Kirsty	Excel Worksheet Functions	2	February 20th 06 11:44 AM
Embed a countif function in subtotal function?	Stuck at work	Excel Worksheet Functions	1	February 14th 06 03:19 AM

All times are GMT +1. The time now is 10:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us