Excel Newbie Needs Help!

[finklestein09]

Hey everyone, I'm fairly new to making complex spreadsheets in excel, and I'm trying to do something way out of my league! I have an order form where I track individual orders and then add them all up at the end of the day to track total purchase of each product. Right now I'm counting everything by hand, but I'm wondering if there is a way to make it automated. I've figured out how to make a drop-down list, and wanted to be able to choose a product from the list and put the quantity in the next column over. Then, I would like to add up all the orders for each specific product. Is this possible? I'm not sure I've explained myself clearly, so let me know if you need clarification. I've attached a sample of the order form as it is now (but I'm definitely willing to change the layout if that will make formulas work more smoothly!) Thanks everyone!

[finklestein09]

How can I change the title of this thread? I need to make it more descriptive of the problem....

[SDCh]

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more days have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

Regards,
SDCh.

[SDCh]

See the attachment This is just an example, you can develop for the better.


Regards,
SDCh

[arlu1201]

finklestein,

Please change your thread title.