Sumproduct checking between two dates

[bikergsx]

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.

[Arvi Laanemets]

Hi
=SUMPRODUCT(--(B1:B2>=A1),--(B1:B2<A2),C1:C2)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


"bikergsx" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[bikergsx]

Many thanks for your quick reply.

Works wonderfully. Thanks.