ExcelBanter - Totalling data from several workbooks to a Summary Sheet

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Totalling data from several workbooks to a Summary Sheet (https://www.excelbanter.com/excel-worksheet-functions/258614-totalling-data-several-workbooks-summary-sheet.html)

Phillip Anderson

Totalling data from several workbooks to a Summary Sheet

I am trying (unsuccessfully) in creating a formula, that will allow me to
total data from several workbooks, to a Summary sheet within Excel.

Does anyone know how to complete this?

L. Howard Kittle

Totalling data from several workbooks to a Summary Sheet

A guess, although may not do what you want...? Maybe gives you a hint
depending on your ultimate requirement.

=SUM(Sheet2!F1:F5,Sheet3!G1:G5)

HTH
regards,
Howard

"Phillip Anderson" wrote in
message ...
I am trying (unsuccessfully) in creating a formula, that will allow me to
total data from several workbooks, to a Summary sheet within Excel.

Does anyone know how to complete this?

All times are GMT +1. The time now is 08:39 AM.