How can I get a total across multiple spreadsheets?

  • Thread starter Margaret McCullough
  • Start date
M

Margaret McCullough

I have a workbook that contains 4 spreadsheets (ss). The first ss is a grand
total of the remaining ss. I'm trying to pull the numbers from the 3
spreadsheets onto the first spreadsheet so I have a total of certain numbers.
Any help would be greatly appreciated!!
 
F

Frank Kabel

Hi
=SUM('sheet1:sheet4'!A1)

--
Regards
Frank Kabel
Frankfurt, Germany

"Margaret McCullough" <Margaret (e-mail address removed)>
schrieb im Newsbeitrag
news:[email protected]...
 

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

Mail Merge Directory Conditional Page Break 0
Page numbering with Merged Document and IF statements 1
Need Help with a VBA subroutine 0
Filtering data from a non-continuous list 3
Get percentage of whole 2
Microsoft Excel Total Values 2
Excel not totaling right amount 4
How do I sum here using criteria there? 10

Top