Try:
=SUMPRODUCT((A2:A7="Apple")*(B2:B7="m")*(C2:C7=2)* D2:D7)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Noel" wrote in message
...
Hi Jim,

Thanks for your reply but it seems that it's a partial answer to my
question
or i may not be getting you. Let me try again.

Fruit Size Wt Price
Apple m 1 0.1
Apple s 2 0.2
Grape l 3 0.2
Banana s 1 0.25
Pear m 2 0.35
Apple m 2 0.1


Based on the table above, my customer asks me what's the price of aN
APPLE,
M size and weight is 2. I may have several entries of APLLES with
different
SIZES and WEIGHTs but I need the price for a specific condition/criteria
given.

Thanks again.