Help with order sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1459080%22%20slang%3D%22en-US%22%3EHelp%20with%20order%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459080%22%20slang%3D%22en-US%22%3EHi%2C%20I%E2%80%99m%20hoping%20someone%20can%20help%20me.%20I%E2%80%99m%20trying%20to%20set%20up%20an%20order%20sheet%20on%20excel%20where%20I%20can%20keep%20a%20track%20of%20customer%20orders%2C%20names%20and%20addresses%20and%20then%20have%20a%20total%20number%20of%20items%20ordered%20at%20the%20bottom.%20So%20I%20want%20to%20have%20in%20the%20first%20column%20the%20customers%20name%2C%20second%20column%20their%20address%2C%20third%20column%20their%20order%20(which%20could%20be%20multiples%20of%20different%20orders)%20and%20then%20fourth%20column%20a%20total%20price%20for%20that%20customer.%3CBR%20%2F%3EI%E2%80%99m%20trying%20to%20work%20out%20a%20way%20to%20get%20a%20total%20at%20the%20bottom%20of%20how%20many%20of%20each%20item%20has%20been%20ordered%20across%20all%20customers.%20So%20for%20example%2C%20customer%20A%20orders%20white%20choc%20blondie%2C%20biscoff%20blondie%2C%20customer%20B%20orders%20raspberry%20brownie%2C%20customer%20C%20orders%20white%20choc%20blondie%2C%20raspberry%20brownie.%20I%20want%20to%20find%20a%20way%20for%20excel%20to%20show%20me%20how%20many%20white%20choc%20blondies%20are%20ordered%2C%20how%20many%20raspberry%20brownies%20are%20ordered%20etc.%20I%20hope%20this%20makes%20sense%20and%20someone%20can%20help%20me!!%3CBR%20%2F%3EThank%20you%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1459080%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1459581%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20order%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459581%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F697749%22%20target%3D%22_blank%22%3E%40Hannah16%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHannah%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20not%20good%20design%20practice%20to%20combine%20customer%20details%20and%20orders%20into%20one%20table%20-%20it%20is%20better%20to%20have%20a%20customer%20table%20and%20an%20orders%20table.%20I%20have%20done%20a%20simple%20design%20to%20show%20a%20customer%20table%20and%20an%20orders%20table.%20Associated%20with%20the%20order%20table%20are%20two%20'pivot%20tables'%20-%20the%20pivot%20tables%20allow%20you%20to%20present%20the%20data%20in%20may%20different%20ways.%20I%20have%20shown%20one%20by%20customer%26nbsp%3B%20and%20one%20by%20order.%20These%20are%20just%20examples%20but%20there%20are%20many%20different%20options.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPeter%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor
Hi, I’m hoping someone can help me. I’m trying to set up an order sheet on excel where I can keep a track of customer orders, names and addresses and then have a total number of items ordered at the bottom. So I want to have in the first column the customers name, second column their address, third column their order (which could be multiples of different orders) and then fourth column a total price for that customer.
I’m trying to work out a way to get a total at the bottom of how many of each item has been ordered across all customers. So for example, customer A orders white choc blondie, biscoff blondie, customer B orders raspberry brownie, customer C orders white choc blondie, raspberry brownie. I want to find a way for excel to show me how many white choc blondies are ordered, how many raspberry brownies are ordered etc. I hope this makes sense and someone can help me!!
Oh, and I also want to add a value to each item, so to add the price to each of the items to then get a total price in the final column. If anyone knows how to do this it would be greatly appreciated
Thank you
1 Reply

@Hannah16 

 

Hannah,

 

It is not good design practice to combine customer details and orders into one table - it is better to have a customer table and an orders table. I have done a simple design to show a customer table and an orders table. Associated with the order table are two 'pivot tables' - the pivot tables allow you to present the data in may different ways. I have shown one by customer  and one by order. These are just examples but there are many different options.

 

I hope this helps!

 

Peter