Adding numbers from sheet 2 to sheet 1

C

caseysmydog

Basically I have a list of names down the sheet and across the sheet by
months I have a number.
Each column (month) is added and put in bottom cell for that column, ie.,
=sum(e3:e50)

The second sheet is the same but a different list of names. I also sum these
by month at the bottom.

How can I change the formula for each column on sheet 1total to include the
corresponding column total from sheet 2?
Many thanks.
 
R

Roger Govier

Hi David

Either
=SUM(E3:E50)+SUM(Sheet2!E3:E50)
0r
=SUM(E3:E50)+Sheet2!E51
Assuming E51 holds the sum of the values in sheet2
 
C

caseysmydog

-- Worked like a charm....MANY THANKS
David


Roger Govier said:
Hi David

Either
=SUM(E3:E50)+SUM(Sheet2!E3:E50)
0r
=SUM(E3:E50)+Sheet2!E51
Assuming E51 holds the sum of the values in sheet2
Click to expand...
 

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

Excel Rainfall Formula 2
Consistent Sheet column header rows 2
Excel Is this possible?? 3
referencing another sheet and using auto fill 10
Sum across sheets 1
customised sheet from master sheet 3
Help Automatically Populating A Summary sheet 1
data from one sheet to several in sequential order! 6

Top