Using Excel 2002, I need to summarize data from a worksheet on 8 different spreadsheets into a new spreadsheet for a supervisor to look at the totals. Each of the 8 spreadsheets are identical in format with 5 worksheets of data. I am only interested in summing up the 3rd sheet of each spreadsheet into the master excel file for the big boss.

The spreadsheets will all be located on the same network drive in the same folder.

Try using just a =SUM() function: I take it that you have several Workbooks, comprised of several Worksheets,

so something like:=SUM('[BOOK1.xlsm]Sheet3'!$A$1:$A$56,'[BOOK2.xlsm]Sheet3'!$A$1:$A$56)

MIKE

Thank you very much for the response. I am shocked that the sum functioned worked so well over our network but consolidate would not. I guess thats what our company gets for holding on to Office 2002 for so long. I appreciate the help immensely.

consolidate would notI've never used the CONSOLIDATE function, so I'm not real familiar with it,

but my best guess is would be that your doing across a network may be

the problem.I give it a test on my 2010 and it worked OK across two open workbooks.

The path names should be identical to using just the =SUM() function.

MIKE

Ask Your Question

Weekly Poll