Help with SumIf

  • Thread starter Thread starter retro
  • Start date Start date
R

retro

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$24>A2),$B$2:$B$24)




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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rearranging the data 1
Trickey SumProduct with Multiple Conditions 1
Combine Sumif and Countif 3
Macros 2
Vlookup for multiple values 6
Finding the first and last entry in a column 2
SumProduct - With Or Function 2
Row references 1

Back
Top