How do I add cells from sheet to sheet?
 

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?

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!
--
Gary's Student


"Jennifer M" wrote:

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?