Hi Jamesy

Does column C contain Excel dates, or are the entries text? If they are
dates, then try this:
=SUMPRODUCT(--(A2:A6="Green Tea"),--(C2:C6=DATE(2006,1,1)),--(B2:B6))

Andy.

"Jamesy" wrote in message
...
Help!

I can't seem to get this simply formula to work!

Heres an example....

Col A Col B Col C
Green Tea £1.00 1st January 2006
Green Tea £1.00 25th October 2005
Green Tea £1.00 5th January 2006
Red Tea £2.00 8th February 2006
White Tea £3.00 20th December 2005


Now in short what I require is a function to look up "Green Tea", then
ONLY
return the product price value if equal to or greater than 1st January
2006,
so the answer would be £2.00.

Your help again is always appreciated.

Thanks,
James.