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