Posted to microsoft.public.excel.worksheet.functions

Manos

external usenet poster

Posts: 50

Count IF Function

Dear all

I have a column with multi same entries and i want to count them as per
category.
So if i have in colum b same entries such as "category a" for 20 entries
in a column with 5000 entries and bring them by sort filter, how i can count
them after that?

Any way to do ti by count if fomrula?

Thaks for your time

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
COUNT Function	Richard	Excel Worksheet Functions	3	March 12th 07 04:38 PM
Count function	Liz23	Excel Worksheet Functions	2	March 15th 06 02:21 PM
using the count function	barklek	Excel Discussion (Misc queries)	3	August 22nd 05 01:00 PM
Count Function Help	Josh O.	Excel Worksheet Functions	4	July 29th 05 11:04 PM
Sum and Count Function	Daniell	Excel Worksheet Functions	0	November 2nd 04 12:03 AM

All times are GMT +1. The time now is 04:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us