How do I add cells from sheet to sheet?

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

Guest

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!
 
You must log in or register to reply here.

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

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
INDIRECT with Sheet Level Defined Name 2
add hyperlink using sheet names and cells(i,j) 3
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Excel - Summing common cell over mutiple sheets within a file? 5
Automatic Sumning of Same Cell from Different Sheets 3
linking a range of cells (=) to another range 4
Dependent drop down dynamic range formula, off sheet. 7

Back
Top