Help with SumIf
 

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!

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!

=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!

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!