silverm00n Posted November 16, 2006 Share Posted November 16, 2006 Can anyone tell me how to create a spreadsheet in excel that simply adds and subtracts any numbers that I enter? I'm reading and reading in their help thingy and have developed an enormous headache and still no answers Please please, lol! Quote Link to comment Share on other sites More sharing options...
scntdwik Posted November 16, 2006 Share Posted November 16, 2006 You need to enter formulas into the rows that you want to be calculated.Or you can use the calculate button at the top when you get done entering your #'s.Have you ever done formulas? Quote Link to comment Share on other sites More sharing options...
silverm00n Posted November 16, 2006 Author Share Posted November 16, 2006 no :embarasse Quote Link to comment Share on other sites More sharing options...
SSR Candles Posted November 16, 2006 Share Posted November 16, 2006 Well, it's actually fairly easy, but it has to be setup using formulas. Use the help system on the SUM function - that's about the easiest way to simply add (or subtract) a whole group of numbers. If you need more in depth help, PM me, and I'll be glad to help out - I've been using excel for all my business spreadsheets and financial calculations for years. Quote Link to comment Share on other sites More sharing options...
silverm00n Posted November 16, 2006 Author Share Posted November 16, 2006 Well, it's actually fairly easy, but it has to be setup using formulas. Use the help system on the SUM function - that's about the easiest way to simply add (or subtract) a whole group of numbers. If you need more in depth help, PM me, and I'll be glad to help out - I've been using excel for all my business spreadsheets and financial calculations for years.Hmm... tried to PM you but it says you won't allow it. Quote Link to comment Share on other sites More sharing options...
scntdwik Posted November 16, 2006 Share Posted November 16, 2006 Ok, then it may be easier just to highlight all your #'s when your finished and hit the calculate button on the toolbar...Enter all your #'s you want calculated, Highlight them including one extra space underneath the bottom of the list and then go up to your toolbar and hit the calculate button. The button should be near the center of the toolbar. Quote Link to comment Share on other sites More sharing options...
SSR Candles Posted November 16, 2006 Share Posted November 16, 2006 Ugh. I still haven't figured out half of this forum system - I can't even find where to set it to let me receive them, much less where to edit my sig. Maybe I'm still too new here, I dunno...Anyways, since the board won't let you do that, feel free to email me - candles at sandstoneranch dot com. If the calculate suggestion doesn't work, of if you'd like it anyway, I'd be glad to throw together a simple sheet for you - all I need to know is what you need it to do. With excel, sometimes it's easier to show rather than explain...Hmm... tried to PM you but it says you won't allow it. Quote Link to comment Share on other sites More sharing options...
silverm00n Posted November 16, 2006 Author Share Posted November 16, 2006 Ugh. I still haven't figured out half of this forum system - I can't even find where to set it to let me receive them, much less where to edit my sig. Maybe I'm still too new here, I dunno...Anyways, since the board won't let you do that, feel free to email me - candles at sandstoneranch dot com. If the calculate suggestion doesn't work, of if you'd like it anyway, I'd be glad to throw together a simple sheet for you - all I need to know is what you need it to do. With excel, sometimes it's easier to show rather than explain...Thank you for the offer, is that the same address as the one listed in your profile?As for your PM's, it's easy to fix. Go to User CP at the top in the blue menu bar. Then down to Edit Options, scroll down and there is a setting that says "enable private messages" Quote Link to comment Share on other sites More sharing options...
silverm00n Posted November 16, 2006 Author Share Posted November 16, 2006 Ok, then it may be easier just to highlight all your #'s when your finished and hit the calculate button on the toolbar...Enter all your #'s you want calculated, Highlight them including one extra space underneath the bottom of the list and then go up to your toolbar and hit the calculate button. The button should be near the center of the toolbar.I don't see the calculate button... Quote Link to comment Share on other sites More sharing options...
SSR Candles Posted November 16, 2006 Share Posted November 16, 2006 Thank you for the offer, is that the same address as the one listed in your profile?As for your PM's, it's easy to fix. Go to User CP at the top in the blue menu bar. Then down to Edit Options, scroll down and there is a setting that says "enable private messages"Yup same email. As for the PM's, I don't have the option to enable them - I guess I can't yet . Quote Link to comment Share on other sites More sharing options...
silverm00n Posted November 16, 2006 Author Share Posted November 16, 2006 Yup same email. As for the PM's, I don't have the option to enable them - I guess I can't yet .Hmmm thats weird. Ok emailed ya...thank you! Quote Link to comment Share on other sites More sharing options...
Everito Bandito Posted November 16, 2006 Share Posted November 16, 2006 You can use pm's once you have been a member for 30 days or something like that. It used to be 8 days and 8 posts but I think they changed it to 8 posts and 30 days. Quote Link to comment Share on other sites More sharing options...
sockmonkey Posted November 16, 2006 Share Posted November 16, 2006 I don't see the calculate button... It's that funny looking symbol that sort of looks like an E.To multiply type:sum(a1*b1) {hit enter}The equation above represents the column and row you want to multiply--Column A, cell #1 times Column B, cell #1Here are a couple of links that might be useful:http://www.usd.edu/trio/tut/excel/13.htmlttp://www.excel-vba.com/microsoft-excel-signs-formulas.htm. Quote Link to comment Share on other sites More sharing options...
silverm00n Posted November 16, 2006 Author Share Posted November 16, 2006 Thank you! Quote Link to comment Share on other sites More sharing options...
LaVida Posted November 16, 2006 Share Posted November 16, 2006 or: for example and to try (for adding box totals).....in box b2 type $2.00in box b3 type $3.00in box b4 type @sum( then immediately after typing @sum( put cursor or scroll up to box b3 hold down SHIFT key and while holding SHIFT key highlight box b2 as well then let go and hit the ENTER keyvoila there's your total $5.00I hope it helped a little bit... :undecided Quote Link to comment Share on other sites More sharing options...
Nanasnecessities Posted November 17, 2006 Share Posted November 17, 2006 You have a formula button that will walk you through it, try help, then formula. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.