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.
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.