Office & Productivity Software forum

General discussion

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

by ASH3S / October 4, 2005 4:24 AM 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
You are posting a reply to: Excel: A Way to make total from one sheet appear on another?
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: Excel: A Way to make total from one sheet appear on another?
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
Sure, =Sheet2!A10
by ChuckT / October 4, 2005 5:10 AM 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.

Collapse -
From one sheet to another...weekly
by ShelliL / October 25, 2015 7:26 PM PDT
In reply to: Sure, =Sheet2!A10

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
by Kees_B Forum moderator / October 27, 2015 3:24 AM 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?


Popular Forums
Computer Help 51,912 discussions
Computer Newbies 10,498 discussions
Laptops 20,411 discussions
Security 30,882 discussions
TVs & Home Theaters 21,253 discussions
Windows 10 1,672 discussions
Phones 16,494 discussions
Windows 7 7,855 discussions
Networking & Wireless 15,504 discussions


The most beautiful phone ever has one wildly annoying issue

The Samsung Galaxy S8's fast speeds and fantastic curved screen make it a top phone for 2017, but the annoying fingerprint reader could sour your experience.