Summing Values from different workbooks

P

Playa

Is it possible to get the sum of values from different workbooks. For
example I want the sum of N33 from five different workbooks. Is this
possible and how?

Thanks in advance
 
T

tjtjjtjt

It is possible--you must include the Filepaths, Filenames and Sheet names in
the formula.
the easiest way to do it manually is to open all of the workbooks you wish
to SUM from.
Start the Function in the Workbook you want the total to appear in.
Click from workbook to workbook Selecting the cell you want and typing a
comma before you go to the next workbook.
You will be limited to 30 workbooks using this method.

Perhaps someone will be able to give you a macro that will automate this for
you, but this is how you can do it manually.

tj
 
D

duane

'Drive\Directory\Folder\[workbookname.XLS]sheetname'!$n$43

and add this for the workbooknames you ean
 
H

Harlan Grove

Playa said:
Is it possible to get the sum of values from different workbooks. For
example I want the sum of N33 from five different workbooks. Is this
possible and how?
Click to expand...

N33 from worksheets with the same name in different workbooks? If so,
another alternative is Data > Consolodate.
 
Top