Solved Need Formula To Sum Values From Multiple Sheets

December 6, 2013 at 09:16:55
Specs: Windows XP
I am preparing year end numbers for one of our clients. I have several different worksheets I am working on in one workbook. I have to take totals form one worksheet and add them to another to get final totals. My problem is that when I try to copy and paste the one set of totals, they are not the correct numbers. For instance: the total is 687,862.00, when I paste to the next worksheet is is 677,452.00. Does anyone know what I may be doing wrong, and what I need to do to fix this.

See More: Need Formula To Sum Values From Multiple Sheets

Report •

December 6, 2013 at 11:44:41
✔ Best Answer
Are you Pasting the Formula or are you Pasting the Values?

From the Edit menu,
select Paste Special

The Paste Special dialog box should appear

You can now select either to
Paste just the Values
Paste the Formula

The default behavior is to Paste the Formula.

And just so you know, Excel questions are best asked in the Office Software Forum.


message edited by mmcconaghy

Report •

December 6, 2013 at 12:40:00
I believe that there is also a way to just put a link from a cell on one worksheet to a cell on the other. This will make sure that any changes are updated rather than just copying the value. As above, you should have asked this in the Office forum.

You have to be a little bit crazy to keep you from going insane.

Report •

December 7, 2013 at 17:08:51

When posting in a help forum, please try to use a subject line that specific to the contents of your post.

If everyone used generic subject lines like "Excel 2003 Help" (something we see a lot!) then we couldn't tell one question from another and things would get very confusing around here.

I fixed the subject in this thread, but we'd appreciate it if you could keep that in mind for future posts.


Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question