@sum from two pages

  • Thread starter Thread starter Rick Hoffman
  • Start date Start date
R

Rick Hoffman

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!
 
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,

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
 
Thanks. That worked fine! I knew it wasn't hard but couldn't find it
easily in the MS help...how unusual!
 
Back
Top