Consolidate function

  • Thread starter Thread starter Brenda Hutton
  • Start date Start date
B

Brenda Hutton

A user wants to add the totals of cell M22 from 14 different workbooks into
cell A1 of a 15th workbook. What is the best way to do this? He is trying
to do a concantonate function, and I do not follow how that works at all.
What is the best way to do this?
 
Brenda

Do you mean 14 "worksheets" in one workbook or 14 workbooks(files)?

If the former enter this in a cell in sheet15.

=SUM(Sheet1:Sheet14!M22)

Note: Sheet15 must be first or last in order.

Gord Dibben Excel MVP
 
It is 14 different FILES.

I played with the SUM function which appears to do what he wants although it
sure is one ugly formula. The SUM function also appears to have a limit of
5 so I am still playing with it. Am waiting word back from the user.
 
Back
Top