View Single Post
  #3   Report Post  
Grant0193 Grant0193 is offline
Junior Member
 
Posts: 2
Default

Quote:
Originally Posted by Claus Busch View Post
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
--
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.