If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Question about Simple task
Hey everyone, I'm currently running an ebay involving the buying of lots of video games, and then the selling of invidual games. I would like to have three columns. One would consist of the Title of the game, in alphabetical order, one the quantity of games I would acquire, and the other the approximate price of that game (Which I research on my own) This is what I want to know, how would I set excel up so that when I put a "1, or 2" in the quantity column it would automatically add to the bottom "grand total" the price of that game which was filled in as having a quantity of 1, or 2. I'm not being very eloquent about all of this, but I'm hoping someone gets it and can either tell me how to do this, or give me a link about how to do it! Thank you very much guys. -- aksama ------------------------------------------------------------------------ aksama's Profile: http://www.excelforum.com/member.php...o&userid=30048 View this thread: http://www.excelforum.com/showthread...hreadid=497292 |
#2
|
|||
|
|||
Question about Simple task
aksama, how about adding another column, and letting excel total the cost
for each title like this, =B2*C2, with game quantity in B2 and cost in C2 and copy down, then you could just sum on that column, may want to put your totals at the top so when you add more games you want have to add rows, does this help? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "aksama" wrote in message ... Hey everyone, I'm currently running an ebay involving the buying of lots of video games, and then the selling of invidual games. I would like to have three columns. One would consist of the Title of the game, in alphabetical order, one the quantity of games I would acquire, and the other the approximate price of that game (Which I research on my own) This is what I want to know, how would I set excel up so that when I put a "1, or 2" in the quantity column it would automatically add to the bottom "grand total" the price of that game which was filled in as having a quantity of 1, or 2. I'm not being very eloquent about all of this, but I'm hoping someone gets it and can either tell me how to do this, or give me a link about how to do it! Thank you very much guys. -- aksama ------------------------------------------------------------------------ aksama's Profile: http://www.excelforum.com/member.php...o&userid=30048 View this thread: http://www.excelforum.com/showthread...hreadid=497292 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
A simple Architectural Question !! | Bernard Piette | Database Design | 7 | December 21st, 2005 01:26 PM |
SIMPLE QUESTION? SORTING A TABLE | Carol | General Discussion | 1 | December 17th, 2005 02:17 AM |
Task Pane/Help System question | Dr. Indera | New Users | 2 | October 27th, 2005 01:18 AM |
Task Pane Question | GJH | Powerpoint | 1 | September 22nd, 2005 04:26 PM |
Simple Formattinmg Question | John Baker | General Discussion | 3 | March 1st, 2005 11:56 AM |