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.

Post a reply
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 49,613 discussions
Computer Newbies 10,349 discussions
Laptops 19,436 discussions
Security 30,426 discussions
TVs & Home Theaters 20,308 discussions
Windows 10 360 discussions
Phones 15,802 discussions
Windows 7 7,351 discussions
Networking & Wireless 14,641 discussions

CNET Holiday Gift Guide

Looking for great gifts under $100?

Trendy tech gifts don't require a hefty price tag. Choose from these CNET-recommended useful and high-quality gadgets.