Excel help needed

[selena]

It's been a long time since I made daily use of excel, and if I knew how to do this, I have forgotten how. I have messed with this off and on for the last day, and I can't make it do what I want it to.

I have a workbook with 4 worksheets in it. On WS3, I have a column that totals in a single cell.

Right now, I am having to manually transfer that total (just the numbers, not the formula that created the total) over to WS4, where I want it to go into a single cell that will get added together with other things.

I don't want to have to manually transfer it, as a) I am lazy and b) I transpose numbers a lot, and don't want to screw it up.

Everything I have tried thus far copies the formula that was used to create the original total on WS3, not just the number that represents the total.



Suggestions?

[Way3]

I think this is what you are looking for:

http://www.ozgrid.com/Excel/Sum.htm

Hope it helps!

[SteveHardeman]

Click on the cell in WS4 you want the data in. Hit "=", then hit the WS3 tab and click on the cell that contains the source data, hit "enter". Done.

If I'm understanding you correctly, that's all you need to do.

[Matyko]

Steve is da maaaan!!! :D

[Iron Fist]

Just hit the = sign in the space where you want the sum

then type SUM(

then click on the other worksheet and select the cells you want to add up... hold down CTRL to select multiple cells, or SHIFT to select all within.

then type ) and hit ENTER... should give you a formula that looks kinda like this

=SUM('WS3'!A3:A5)

which mean on worksheet WS3 add up all in A3, A4 and A5...

change to what you need

[selena]

Click on the cell in WS4 you want the data in. Hit "=", then hit the WS3 tab and click on the cell that contains the source data, hit "enter". Done.

If I'm understanding you correctly, that's all you need to do.

That totally did it, thank you soooooooooooooooo much!

And I appreciate the rest of the help too; I'm tucking that stuff away in case I need it and can't remember what to do.

You guys rock.

[PersianKitty]

gawd.. I remember the private sector accounting days when I'd mess with 10 divisions over 2 companies each set of P&Ls and budgets in their own workbook then have to tie it all together in one worksheet so that you didn't have to go back and change everything by hand.. excel did it for you. Pain hunting down problems when the checks for it weren't adding up.

I lived that for way too many years.