Totalling data from several workbooks to a Summary Sheet

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?
 
L

L. Howard Kittle

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
 

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

Dumb question alert! What program to use? 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
How do you make a summary sheet? 0
Adding data to MS Access from csv file 0
Sports summary sheet - think I put this in wrong place originally 1
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Copy summary data to new sheet 1
Macro to count words in a section, excluding footnotes and end notes 1

Top