View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jamesy
 
Posts: n/a
Default SumProduct question

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.