How do I move information between worksheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 12 separate spreadsheets that sum dollar amounts in a single cell. I
created a thirteenth spreadsheet which summarizes all the info. I want to
input a cell formula that will bring the final value into the "Summary"
spreadsheet but can't figure out the right formula to use.
 
Hi

If you are wanting to total the same cell across the 12 sheets, then on
Sheet 13
=SUM(Sheet1:Sheet12!A1)
Or, if you want to vary the range of sheets being summed, then
Create a blank sheet called First, and another called Last and use the
formula
=SUM(First:Last!A1)

Make sure that Sheet13 is outside of the range First and Last, but by
dragging the Last sheet (Right mouse click on sheet tab and drag), then
you can vary the number of sheet being summed.

Regards

Roger Govier
 

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

Moving Cell Formula 1
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Scrabble Value calculation for Welsh words 0
Input dollar amount into a cell that updates another cell and more 7
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Automatically add a column to summary sheet if another worksheet i 2
SUM/COUNTIF across multiple worksheets 7
formula finds values in apparently blank cells 1

Back
Top