Home |
Search |
Today's Posts |
#1
|
|||
|
|||
@sum from two pages
What is the easiest way to add two cells from different pages in a
spreadsheet? If you want to add B45 from the first sheet and C76 from the second sheet and display that sum on a third sheet how would you do it? Thanks! |
#2
|
|||
|
|||
Hi Rick
click where you want the answer and type an = go to the first sheet, click on B45 type a + go to the second sheet, click on C76 type a = OR where you want the answer type =Sheet1!B45+Sheet2!C76 and press enter Note, substitute real sheet names for Sheet1 & Sheet2 and if there's a space in your sheet names you need to surround the sheet name with ' ' e.g. ='First Qtr'!B45+'Second Qtr'!C76 Cheers JulieD "Rick Hoffman" wrote in message ... What is the easiest way to add two cells from different pages in a spreadsheet? If you want to add B45 from the first sheet and C76 from the second sheet and display that sum on a third sheet how would you do it? Thanks! |
#3
|
|||
|
|||
one way:
In a cell on the third sheet: =Sheet1!B45 + Sheet2!C76 In article , "Rick Hoffman" wrote: What is the easiest way to add two cells from different pages in a spreadsheet? If you want to add B45 from the first sheet and C76 from the second sheet and display that sum on a third sheet how would you do it? Thanks! |
#4
|
|||
|
|||
Rick,
The real pros here may have a much simpler/elegant solution. But, FWIW, try the following: Copy the cell B45 in Sheet1 to the desired cell (say, A15) in Sheet3 but use the Paste Special function under Edit and click on Paste Link. In the formula field for A15, in Sheet3 add a plus (+) sign. Repeat these steps copying C76 from Sheet 2 to Sheet3, A15. After selecting C76 in Sheet2 and clicking on COPY, I didn't have to access the Edit/Paste Special/Paste Link function for the second entry; it already appeared in Sheet3, A15. Simply hit ENTER and the sum of the two cells in Sheet1 and Sheet2 appeared. Any changes you make to B45 in Sheet1 and/or C76 in Sheet2 will recalculate to the new sum in A15 of Sheet3. This works for what I understand you're trying to do. I did the foregoing in Excel 2000. Whether the version of Excel you're using works the same way, I can't predict. But it might be worth a try. Don't hesitate to ask any follow up questions. Regards, PJF "Rick Hoffman" wrote in message ... What is the easiest way to add two cells from different pages in a spreadsheet? If you want to add B45 from the first sheet and C76 from the second sheet and display that sum on a third sheet how would you do it? Thanks! |
#5
|
|||
|
|||
Thanks. That worked fine! I knew it wasn't hard but couldn't find it
easily in the MS help...how unusual! "JE McGimpsey" wrote in message ... one way: In a cell on the third sheet: =Sheet1!B45 + Sheet2!C76 In article , "Rick Hoffman" wrote: What is the easiest way to add two cells from different pages in a spreadsheet? If you want to add B45 from the first sheet and C76 from the second sheet and display that sum on a third sheet how would you do it? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Single worksheet, multiple pages? | Excel Discussion (Misc queries) | |||
How do I print row labels on alternating pages of an Excel workshe | Excel Discussion (Misc queries) | |||
How do I remove pages in Excel? | Excel Discussion (Misc queries) | |||
How do I delete pages? | Excel Discussion (Misc queries) | |||
Limiting the # of pages for Repeat Column Labels | Excel Discussion (Misc queries) |