I need to Sum data from 8 spreadsheets into 1 master sheet

March 14, 2012 at 13:27:03
Specs: Windows 7
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.

See More: I need to Sum data from 8 spreadsheets into 1 master sheet

Report •


#1
March 14, 2012 at 14:08:11
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

http://www.skeptic.com/


Report •

#2
March 21, 2012 at 10:13:02
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.


Report •

#3
March 21, 2012 at 11:38:56
consolidate would not

I'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

http://www.skeptic.com/


Report •

Related Solutions


Ask Question