Working out what clothes to get.
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 |
Working out what clothes to get.
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 |
Quote:
"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. |
Working out what clothes to get.
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 |
All times are GMT +1. The time now is 08:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com