Formula Query

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
 
T

Teethless mama

Try like this:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Formula 2
Lookup question 3
Vlookup and return sheet name also 2
SUMIF Greater than or equal to 4
if then statement based on another column 6
Consolidation Table from Different Excel Tabs with Different Format 1
Changing a Formula 2

Top