I'm trying to count some numbers if they are between multiple ranges of #s.
If in this example, count the #s that fall between the start and end dates, if they also fall in a calendar month a3 = 1/1/15, A4 = 2/1/15, A5 = 3/1/15, A6 = 4/1/15 and so on.
Start date = 11/15/14
End Date = 3/31/14
Count_Stuff = For the purposes of this example it's 72 things that are happening between the start and end dates above.
It seems to work until I hit the end date of 3/31/15.
=SUM(SUMIFS(Count_Stuff,Start_Date,"<="&A3,End_Date,">="&A4)) -- Then copy/drag down
Results:
1/1/2015 72
2/1/2015 72
3/1/2015 0
4/1/2015 0
5/1/2015 0
The results for 3/1 - 4/1 should also be 72 since the end date is between those ranges, but it's not working.
Bookmarks