Sumif formula to sum between 2 dates...help

Solved/Closed
Chris - Jun 16, 2010 at 11:03 AM
 Chris - Jun 16, 2010 at 01:36 PM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jun 16, 2010 at 11:47 AM
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)
0
Thanks rizvisa1, i'll chcek this out now
0
Thanks alot...GREAT!!! I have been searching for long
0