| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Query
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Query
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula query | Excel Discussion (Misc queries) | |||
| IF formula query - Help!! | Excel Worksheet Functions | |||
| Formula query | Excel Discussion (Misc queries) | |||
| formula Query | Excel Discussion (Misc queries) | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
