Results 1 to 3 of 3

Thread: In don't know which formula to use???

  1. #1

    In don't know which formula to use???

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Everyone

    The attachment is the spreadsheet I am trying to set up for ordering uniforms at my work. I want to be able to enter what each person has ordered into the top section and have it automatically fill out the bottom table so I know at a glance what I need to order.

    So in cell E17 I need it to look at cells E4:E10 if any of those say S add up the corresponding quantities in column D. This should result in E17 saying 13
    The same would be put in cell E18 but looking for M and so on for the rest of the sizes.

    Hopefully this makes sense.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Solved it Never Mind. LOL

  3. #3
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Derbyshire, UK
    Excel Version
    most versions
    Why not post the solution? It may help others
    Hope that helps


Posting Permissions

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