Thanks but I do not want to use a pivot table,
The reason is that in reality We are talking of 75 different files that all
checking are getting registered, and thgis is the management view, If I make
a pivot table for each one of those files
then How I will be able to consolidate all date in one file. I have to open
each one of them every day and run update to get the update report.

A1 B1 C1 D1 E1
A2 DATE DEPT PERSON
A3 JAN1 SALES A
A4 JAN1 SALES B
A5 JAN1 SALES A
A6 JAN4 MKTG A
A7 etc
A8 TOTAL JAN1 JAN2 JAN3 JAN4
A9 SALES 3 0 0 0
A10 MKTG 0 0 0 1

"Ron Coderre" wrote:

A Pivot Table is probably the easiest approach....
Just make sure you have column headings
(I'll assume: Date,Category,Name)

From the Excel Main Menu....
<Data<Pivot Table
Use: Excel
Select your data
Click the [Layout] button

ROW:
Drag the Date field here
Drag the Category field here and put it under the Date field

DATA: Drag the Name field here
If it doesn't list as Count of Name...dbl-click it and set it to Count
Click [OK]
Select where you want the Pivot Table...and you're done!

That will list each Date/Category combination used and the Count of Names.

To refresh the Pivot Table, just right click it and select Refresh Data

Post back with any questions.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"stratis" wrote:

I have a long 16000 lines sheeet that contains the checking per day per
Section.
ie
Jan 1, Sales, Mr X
Jan 1, Sales, Mr Y
Jan 1, Marketing, Mr Z
Jan 2, Sales, Mr X
Jan 2, Marketing, Mr Z

I want to add the functiion like COunt, or dcount
Jan 1, Sales 2, people
Jan1, Marketing, 1 person
Jan 2, Sales, 1 Person
etc...