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