DCOUNT with different files

S

stratis

I have 40 files that have attendance data
I need to create a consolidated report feeding data from each file that will
summarise counts per date


File 1
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

SALES #VALUE!
MKTG
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the remaining weekdays in a data range excluding holidays and start/end dates 5
how to use an formula to transpose a list(left) to be like the right? 2
How to delete ALL cells containing the same data 0
How to delete ALL cells containing the same data --- REVISED 0
column to row draging 1
COUNT function 2
How to delete ALL cells containing the same data 1
Generate a special numerical sequence in Excel 97 3

Top