sumif formula to sum between 2 dates...help Solved/Closed

Question

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         "

Configuration: Windows XP / Internet Explorer 6.0

rizvisa1 · Answer

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)

Chris · Answer

Thanks rizvisa1, i'll chcek this out now

Chris · Answer

Thanks alot...GREAT!!! I have been searching for long

Sumif formula to sum between 2 dates...help

3 responses

Similar discussions

Subscribe To Our Newsletter!