Excel help needed - GoFuckYourself.com

selena · 05-10-2009, 10:25 AM

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 · 05-10-2009, 11:09 AM

I think this is what you are looking for:

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

Hope it helps!

SteveHardeman · 05-10-2009, 01:46 PM

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 · 05-10-2009, 02:18 PM

Steve is da maaaan!!! :D

Iron Fist · 05-10-2009, 02:28 PM

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 · 05-11-2009, 09:23 AM

Quote:

Originally Posted by 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.

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 · 05-11-2009, 10:24 AM

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.

05-10-2009, 10:25 AM	#1
selena Confirmed User Join Date: Aug 2004 Location: On The Edge Posts: 7,994	Excel help needed 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? __________________ ~ Doer of Things at MetArtMoney Where Flawless Beauty Meets Art ~The MetArt Network ~ selena.delgado9

05-10-2009, 11:09 AM	#2
Way3 Confirmed User Industry Role: Join Date: Mar 2007 Location: Phoenix, Arizona Posts: 1,725	I think this is what you are looking for: http://www.ozgrid.com/Excel/Sum.htm Hope it helps! __________________ FULLY Managed! FREE Control Panel! FREE Month on ALL Shared Accounts!!! ICQ: 169-554-261 Email: info[at]way3{dot}com

05-10-2009, 01:46 PM	#3
SteveHardeman Confirmed User Join Date: Jul 2008 Location: Atlanta Posts: 1,728	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. __________________ BrokeAmateurs And ErosPOV And GirlsGoingSolo And PureAshley Sign Up At AmateursConvert.com Questions? I-C-Q: 3Five1FiveFive3476

05-10-2009, 02:18 PM	#4
Matyko PsyHead Industry Role: Join Date: Aug 2005 Location: Hungary Posts: 8,669	Steve is da maaaan!!! :D __________________ -=- Register with our ref link and we help you with the setup! -=- AdSpyglass.com - Double your profit from brokers

05-10-2009, 02:28 PM	#5
Iron Fist Too lazy to set a custom title Join Date: Dec 2006 Posts: 23,400	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 __________________ i like waffles

05-11-2009, 10:24 AM	#7
PersianKitty Meow Media Inc. Industry Role: Join Date: Jul 2001 Location: In the valley of the sun, cactus, tacos, tequila, and nod Posts: 7,785	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. __________________ Wondering what webmaster programs PK uses? Check them out here!