JalopyJeep
New Member
- Joined
- Jul 13, 2016
- Messages
- 4
I am currently trying to get a total number of entries made during each month within that year. I have been able to use the countifs function successfully i just need it to work with filters.
This is my current formula that i would like to work with filters.
=COUNTIFS(L19:L9994,">="&"5/1/2015",L19:L9994,"<="&"5/31/2015")
Below is an example of the spreadsheet i would like to have populate as the sheet is filtered.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I have already used pivot tables but would like a different method for totaling.
Thank you in advance for any help and tips,
Jeremy
This is my current formula that i would like to work with filters.
=COUNTIFS(L19:L9994,">="&"5/1/2015",L19:L9994,"<="&"5/31/2015")
Below is an example of the spreadsheet i would like to have populate as the sheet is filtered.
2015 | 2016 | TOTAL | |
January | 0 | 126 | 126 |
February | 15 | 105 | 120 |
March | 37 | 70 | 107 |
April | 29 | 66 | 95 |
May | 20 | 44 | 64 |
June | 140 | 37 | 177 |
July | 164 | 11 | 175 |
August | 86 | 0 | 86 |
September | 76 | 0 | 76 |
Octover | 133 | 0 | 133 |
November | 152 | 0 | 152 |
December | 110 | 0 | 110 |
TOTAL | 962 | 459 | 1421 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I have already used pivot tables but would like a different method for totaling.
Thank you in advance for any help and tips,
Jeremy