Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel: A Way to make total from one sheet appear on another?

Oct 4, 2005 4:24AM PDT

In Excel You can add totals of cells by the formula: =SUM(A1:B3) but is there any way, for example, to add a total from sheet 2, and have that total display on sheet 1?

Is there a formula for this?

Thank you for your Help.

Discussion is locked

- Collapse -
Sure, =Sheet2!A10
Oct 4, 2005 5:10AM PDT

That is, if the sum you want onto Sheet1 is in cell A10 of Sheet2.

But you can easily have this entered for you by just going to your Sheet1 (or whatever the name is) and click on the Sheet1 cell, that you want the carry over from Sheet2, and press the equals key (the =).
Then click on the tab for your Sheet2, then
click on the cell that holds that sum,
and press that Enter key.
Done.

- Collapse -
From one sheet to another...weekly
Oct 25, 2015 7:26PM PDT

ChuckT. I saw your post about copying from one from one sheet to another sheet. I have a weekly sum that needs to populate without having to redo the formula every time. I have a report that needs the number from the previous week to be populated and then we subtract this week from it. Is there a code for excel to pull the sum from the previous sheet. There will be 52 sheets per year. I need it to self populate, if you will, because my dad is not an excel user and he won't understand how to do it. I'm trying to make a report that he can easily use. Any ideas? Thanks for your knowledge!! I've been trying for about 8 hours and I'm stumped. Thanks again!!

- Collapse -
Re: formula
Oct 27, 2015 3:24AM PDT

Sure there is.

In sheet2 use =sheet1!a10
In sheet3 use =sheet2!a10
in sheet4 use =sheet3!a10
and so on.

But could it be that Excel is the wrong tool for what you want to do?

Kees