Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DCOUNT with different files
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening files in folders and subfolders | Excel Discussion (Misc queries) | |||
Seemingly random .tmp files | New Users to Excel | |||
How to update destination file with source files closed? | Excel Discussion (Misc queries) | |||
merging my excel files | Excel Discussion (Misc queries) | |||
Cannot access read-only documents. | Excel Discussion (Misc queries) |