Consolidate function

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?
 
G

Gord Dibben

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
 
B

Brenda Hutton

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.
 
Top