Working out what clothes to get.

[Grant0193]

Hey, Im trying to work out what clothes I need for the works.
I need to find out how how many of size and type of clothes I need.
Eg; Nick: Jacket Size:L Quantity:2
Nick: Shirt Size:L Quantity:1

Jake: Jacket Size: S Quantity:1
Jake: Shirt Size: S Quantity:3


https://www.dropbox.com/s/h2e9pth07piqjxn/Workwear.xlsx
Here is the sheet Ive made so far, just cant get the formulas to wor
how I want them.
Can the way I set up the sheet work?

Thank

 

[Claus Busch]

Hi,

Am Fri, 17 May 2013 01:46:00 +0100 schrieb Grant0193:

https://www.dropbox.com/s/h2e9pth07piqjxn/Workwear.xlsx
Here is the sheet Ive made so far, just cant get the formulas to work
how I want them.

for jumpers in S:
=SUMMENPRODUKT(--($B$5:$B$100="Yes");--($C$5:$C$100="S");$D$5:$D$100)
and so on for all other clothes

Regards
Claus Busch

 

[Grant0193]

Hi,
for jumpers in S:
=SUMMENPRODUKT(--($B$5:$B$100="Yes");--($C$5:$C$100="S");$D$5:$D$100)
and so on for all other clothes

Regards
Claus Busch

Thanks for that but I get a error;
"We found a problem with this formula. Try clicking Insert Function o
the Formulas tab to fix it, or clock Help for more into on commo
formula problems.
Not trying to type a formula?
When the first character is an equal (=) or minus (-) sign, Excel think
its a formula"

The first part of the formula I dont need really "Jumper: Yes or No"
just the size and quantity. I dont know if it might help with out thi
part

 

[Claus Busch]

Hi,

Am Sat, 18 May 2013 11:03:14 +0100 schrieb Grant0193:

Thanks for that but I get a error;

sorry, I posted the formula in German. Try:
=SUMPRODUCT(--($B$5:$B$100="Yes"),--($C$5:$C$100="S"),$D$5:$D$100)

Regards
Claus Busch