ExcelBanter - Formula Query

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula Query (https://www.excelbanter.com/excel-worksheet-functions/202888-formula-query.html)

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)

"Mark" wrote:

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