+ Reply to Thread
Results 1 to 2 of 2

Summarise a figure froma list excluding certain items

  1. #1
    Forum Contributor
    Join Date
    10-25-2012
    Location
    london,england
    MS-Off Ver
    365 but on mac
    Posts
    137

    Summarise a figure froma list excluding certain items

    Order book problem.xlsx

    Hi,

    heres another problem I am trying to solve.

    I have 2 order books.

    One is alist of all the orders that I have- customer ,product code,order no., qty,date required

    Two - is alist of promotional orders that I seperate out into the week that it is required

    Two is entered manually as I identify these by the non standard reqiremnt from that customer-I then add it to a further spreadhseet in the week reqd against the product code

    What I am tring to do is caluclate the overall order qty-excluding the promotional requirments, eg my order book for product a- minus the promotional order book.

    I could identify these by order no.s beginning PR if required.

    So I want to compare the order book aginst the promotional order book and reduce the order book by the promotional qty-even if its not on the order book- however if it is on the order book and is on the promotional order book that is fine.As it zeros out.

    However if I add a manual promotional order-eg the customer has told me they want it but havent done the offical order yet so it isnt on my order book-the qty on the order book is reduced by that entry on the promotional order book when it shouldn't be- bit still used as a future order ( eg a requirment without an order) which I can handle???

    any thoughts- I think it may be index match but it wont work for me! or sum if the customer,product code,order no. and qty match one found on the order book?

  2. #2
    Forum Contributor
    Join Date
    10-25-2012
    Location
    london,england
    MS-Off Ver
    365 but on mac
    Posts
    137

    Re: Summarise a figure froma list excluding certain items

    Any Ideas???

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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