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

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