Formula

[Mary Ann]

I'm trying to do a summary page that includes totals from
2 different worksheets. I've tried everything I can find
and have not succeeded. Can you send me the formula?

I want to take 3 totals from 2 different worksheets and
place them on a summary sheet?

 

[BenjieLop]

Assume that :

Total1 is in Cell B100 of Sheet1
Total2 is in Cell L100 of Sheet1
Total3 is in Cell S100 of Sheet2

If your summary page is in Sheet1, your summary total is

=sum(B100+L100+Sheet2!S100)



If your summary page is in Sheet2, your summary total is

=sum(Sheet1!B100+Sheet1!L100+S100)


and if your summary page is in another sheet (besides Sheet1 o
Sheet2), your summary total is

=sum(Sheet1!B100+Sheet1!L100+Sheet2!S100)

Hope this helps you.

 

[Michael]

Hi Mary Ann
Assuming your information is in cells A1, B1 & C1 on
sheets, Sheet1 and Sheet2, Use the following formula.

=Sheet1!A1+Sheet2!B1+Sheet2!C1

HTH
Michael