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 work how I want them.
Can the way I set up the sheet work?

Thanks

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thanks for that but I get a error;
"We found a problem with this formula. Try clicking Insert Function on the Formulas tab to fix it, or clock Help for more into on common formula problems.
Not trying to type a formula?
When the first character is an equal (=) or minus (-) sign, Excel thinks 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 this part.

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2