Adding numbers from sheet 2 to sheet 1
-- Worked like a charm....MANY THANKS
David
"Roger Govier" wrote:
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
--
Regards
Roger Govier
"caseysmydog" wrote in message
...
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.
--
David
|