Sumif formula to sum between 2 dates...help [Solved/Closed]

Report
-
 Chris -
Hello,

I want a formula to sum the cells between 2 dates.

For eg:

Col A Col B
Dates Total
3/2/2010 100
3/3/2010 200
3/4/2010 599
3/5/2010 987
3/6/2010 1000

I want a sum if forluma where...it can find the total between "3/2/2010 to 3/5/2010 "

3 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
761
You can use an array formula or a combination of SUMIFs

This is using sum and sumif
=SUM(B:B) -SUMIF(A:A,"<3/3/2010",B:B)- SUMIF(A:A,">3/5/10",B:B)
Thanks rizvisa1, i'll chcek this out now
Thanks alot...GREAT!!! I have been searching for long

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!