+ Reply to Thread
Results 1 to 3 of 3

Order Form

  1. #1
    Registered User
    Join Date
    07-08-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    7

    Order Form

    I am fairly new to Excel but can do some formulas. I have difficulty with a spreadsheet I have created. I am trying to create a seperate worksheet in the attachment which outlines a couple of things. Basically trying to create a summary sheet of the order form. Wanting to know the name, size and quantity ordered for product code A9089 - Navy L/S, and the same for the additional items in the order form. I would like to have the sheet setup so that it will pull all the orders with sizes and quantity into one sheet - basically giving me an overview of the total shirt quantity and size for each item. Is there a way to create this?
    Attached Files Attached Files
    Last edited by rylo; 07-08-2010 at 08:48 PM.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Order Form

    Hi

    Using your example file:
    1) Enter 4,5,6,7,8,9 in the range 'Product Codes'!E1:J1
    2) 'Product Codes'!E2: =SUMPRODUCT(--(LEFT(Orders!$E$3:$E$9,5)='Product Codes'!$A2),--(Orders!$F$3:$F$9='Product Codes'!E$1),(Orders!$D$3:$D$9))
    3) Copy down / across to fill the range E2:J6

    This will give you the sum of quantity by size.

    HTH

    rylo

  3. #3
    Registered User
    Join Date
    07-08-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Order Form

    Rylo,

    Thank you for the assistance with that......that does work on the initial form quite well. I update a new post with a new spreadsheet with some formula and probably some other problems listed. Any way you can look at that and see what/how I messed up?

    BSM21

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1