Hi all,
I've got a SUMIF formula that works but will be complex to expand. Junt wondering if there is a easier way of doing this is excel 2007
A10= SUMIFS(b2:b4,a2:a4,">="&B6,a2:a4,"<="&C6)+SUMIFS(d2:d4,c2:c4,">="&B6,c2:c4,"<="&C6)
result would be count of dates beween Apr1 - Apr 30. total =9
B10= SUMIFS(b2:b4,a2:a4,">="&c6,a2:a4,"<="&d6)+SUMIFS(d2:d4,c2:c4,">="&c6,c2:c4,"<="&d6)
result would be count of dates between May1 - May31. total= 6
the date range in row 6 will go on for 48 months
<TBODY>
</TBODY>
I've got a SUMIF formula that works but will be complex to expand. Junt wondering if there is a easier way of doing this is excel 2007
A10= SUMIFS(b2:b4,a2:a4,">="&B6,a2:a4,"<="&C6)+SUMIFS(d2:d4,c2:c4,">="&B6,c2:c4,"<="&C6)
result would be count of dates beween Apr1 - Apr 30. total =9
B10= SUMIFS(b2:b4,a2:a4,">="&c6,a2:a4,"<="&d6)+SUMIFS(d2:d4,c2:c4,">="&c6,c2:c4,"<="&d6)
result would be count of dates between May1 - May31. total= 6
the date range in row 6 will go on for 48 months
date1 | count1 | date2 | count2 | date3 | count3 |
4/3/14 | 2 | 5/9/14 | 1 | 4/15/14 | 4 |
5/8/14 | 3 | 4/23/14 | 2 | 5/19/14 | 2 |
4/9/14 | 1 | 8/6/15 | 1 | 1/1/15 | 1 |
date range | 1/4/14 | 1/5/14 | 1/6/14 | 1/7/14 | 1/8/14 |
<TBODY>
</TBODY>