Totalling data from several workbooks to a Summary Sheet

  • Thread starter Thread starter Phillip Anderson
  • Start date Start date
P

Phillip Anderson

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?
 
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
 
Back
Top