MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Question with Formula


Posted by Erick on June 29, 2001 7:22 AM

I AM USING THE FOLLOWING FORMULA TO LOOK DOWN A LIST AND FIND THE AVAILABLE QTY IN STOCK. THE PROBLEM IS THAT IT STOPS ON THE FIRST MATCHING VALUE THAT IT FINDS AND I NEED IT TO ADD UP ALL THE VALUE THAT MEET THE CRITERIA.

=INDEX(RANGE,MATCH(DRESS*,RANGE,0),2) RESULTS IN 10 AND IT SHOULD BE 60

DRESS-B 10
DRESS-C 20
DRESS-D 30

THANKS.


FROM MIAMI, FL.


Posted by IML on June 29, 2001 7:28 AM

Try using a sumif statement. something along the lines of:
=SUMIF(A1:A3,"dress*",C1:C3)

good luck

Posted by Erick on June 29, 2001 7:37 AM

Thanks!! From Miami