With C3 <= D3...

=SUMIF(A2:A24,"="&C3,B2:B24)-SUMIF(A2:A24,""&D3,B2:B24)

reads better.


Aladin Akyurek wrote:
=SUMIF(A2:A24,"<="&C3,B2:B24)-SUMIF(A2:A24,"<"&D3,B2:B24)

retro wrote:

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!