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!