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

Jaws

New member
Joined
Apr 29, 2013
Messages
2
Reaction score
0
Points
0
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.
 

Attachments

  • HELP.xlsx
    10.2 KB · Views: 9
Top