ExcelBanter - Summing Values from different workbooks

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Summing Values from different workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/648-re-summing-values-different-workbooks.html)

Harlan Grove

Summing Values from different workbooks

"Playa" wrote...
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?

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

All times are GMT +1. The time now is 10:15 AM.