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.