HOW DO I CALCULATE SEPARATE WORKBOOKS INTO ONE?

C

Cindy

I would like to take separate workbook totals and create a workbook that will
calculate all of the totals inputted without having to manually go into the
workbook and input the totals.
Example if i have monthly total in one workbook say Feb and in another
workbook I have March's monthly total and so on, how would I take those
totals and have them automatically transfer to another workbook that would
give me year end totals?
 
D

Duke Carey

A variation on Gary's suggestion, in case your monthly totals aren't all in
the same cell addresses: give each total a range name, MonthlyTotal

Then Gary's formula could be changed to

=Jan.xls!MonthlyTotal + Feb.xls!MonthlyTotal + Mar.xls!MonthlyTotal.....
 
Top