Formula Query

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I'm still having problems with a formula that was the solution to an earlier
problem. The formula below doesn't return a figure. I'm guessing that the
format of the date is incorrect. This is what I'm using
=SUMPRODUCT(--(RBS!A2:A200>=1/4/2008),--(RBS!A2:A200<=31/3/2009),--(RBS!B2:B200="Petrol"),RBS!C2:C200)

Column A is a range of dates that are constantly being added to.
Column B is the description of the item in question.
Column C is the price for that item.

Many thanks in advance for your help.

Mark
 
Try like this:

=SUMPRODUCT(--(RBS!A2:A200>="1/4/2008"),--(RBS!A2:A200<="31/3/2009"),--(RBS!B2:B200="Petrol"),RBS!C2:C200)
 
Back
Top