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.
 
He appears to be satisified with the results of the SUM function. Thanks.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Formula 2
Formula within filename link 2
Help on consolidate worksheets from different workbooks into one 2
consolidate numbers by position from sheets in different workbook. 2
consolidate data 2
Sharing workbooks limitations - Merged Cells 12
Continue Excel to New Uear 9
Consolidate Data 4

Back
Top