Hi,

Maybe you want to try

=SUMPRODUCT(--($C$2:$C$24<=A2),--($D$2:$D$24A2),$B$2:$B$24)



"retro" wrote in message
. ..

I have dates in A, numbers in B, start dates in C and a finish dates in D.
How do I get the sum of the numbers between the start and finish date? I
have tried...
=SUMIF(A2:A24,"<=C3",B2:B24)-SUMIF(A2:A24,"<D3",B2:B24) and
=SUMIF(A2:A24,"=C3=<D3",B2:B24) and other variations. Thanks for any help!