Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct checking between two dates
Hello, I appear to be having a little difficulty with sumproduct. A1 = 01/06/2006 (dd/mm/yyyy format) A2 = 01/07/2006 B1 = 01/06/2006 B2 = 01/07/2006 C1 = 10 C2 = 20 The formula I'm using is : =SUMPRODUCT(--(B1:B2=--A1),--(B1:B2<--A2),C1:C2) This results in a value of '0'. I was expecting a value of '10'. Any advice, please? Many thanks. Best regards from the UK, Rob. -- bikergsx ------------------------------------------------------------------------ bikergsx's Profile: http://www.excelforum.com/member.php...o&userid=28834 View this thread: http://www.excelforum.com/showthread...hreadid=545773 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct checking between two dates
Hi
=SUMPRODUCT(--(B1:B2=A1),--(B1:B2<A2),C1:C2) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "bikergsx" wrote in message ... Hello, I appear to be having a little difficulty with sumproduct. A1 = 01/06/2006 (dd/mm/yyyy format) A2 = 01/07/2006 B1 = 01/06/2006 B2 = 01/07/2006 C1 = 10 C2 = 20 The formula I'm using is : =SUMPRODUCT(--(B1:B2=--A1),--(B1:B2<--A2),C1:C2) This results in a value of '0'. I was expecting a value of '10'. Any advice, please? Many thanks. Best regards from the UK, Rob. -- bikergsx ------------------------------------------------------------------------ bikergsx's Profile: http://www.excelforum.com/member.php...o&userid=28834 View this thread: http://www.excelforum.com/showthread...hreadid=545773 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct checking between two dates
Many thanks for your quick reply. Works wonderfully. Thanks. -- bikergsx ------------------------------------------------------------------------ bikergsx's Profile: http://www.excelforum.com/member.php...o&userid=28834 View this thread: http://www.excelforum.com/showthread...hreadid=545773 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Receive #VALUE! when I mix text with dates using SUMPRODUCT | Excel Worksheet Functions | |||
sumproduct between two dates | Excel Worksheet Functions | |||
Sumproduct and list of dates | Excel Discussion (Misc queries) | |||
SUMPRODUCT ON DATES | Excel Worksheet Functions | |||
sumproduct between dates | Excel Worksheet Functions |