How do I add cells from sheet to sheet?

J

Jennifer M

I am trying to add the answer of a sum range of cells to the answer on
another sheet of a range of cells . This is on a worksheet that can not be
changed.
Can anyone help me?
 
G

Gary's Student

Lets say you have data in cells A1,A2,A3 in sheet1 and the same in sheet2,
then in any sheet in the workbook enter:

=SUM(Sheet1!A1:A3)+SUM(Sheet2!A1:A3)

will give you the total sum from both sheets


Have a good day!
 
Top