Created
August 16, 2018 18:08
-
-
Save vargonaut/3dc93ddaaffea79e423c6e53d8374674 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| The $C2:$C13 for the COUNTIF should actually be the selection for the entire set of computed month. | |
| In my example, it should really be $C2:$C3. | |
| | tool | start date | computed month | | month | count | | |
| |--------+-----------------+----------------+---+---------+---------------------------| | |
| | drill | Sept 15, 2019 | 2019-09 | | 2018-10 | =COUNTIF($C$2:$C$13, E2) | | |
| | hammer | October 8, 2018 | 2018-10 | | 2018-11 | =COUNTIF($C$2:$C$13, E3) | | |
| | | | | | 2018-12 | =COUNTIF($C$2:$C$13, E4) | | |
| | | | | | 2019-01 | =COUNTIF($C$2:$C$13, E5) | | |
| | | | | | 2019-02 | =COUNTIF($C$2:$C$13, E6) | | |
| | | | | | 2019-03 | =COUNTIF($C$2:$C$13, E7) | | |
| | | | | | 2019-04 | =COUNTIF($C$2:$C$13, E8) | | |
| | | | | | 2019-05 | =COUNTIF($C$2:$C$13, E9) | | |
| | | | | | 2019-06 | =COUNTIF($C$2:$C$13, E10) | | |
| | | | | | 2019-07 | =COUNTIF($C$2:$C$13, E11) | | |
| | | | | | 2019-08 | =COUNTIF($C$2:$C$13, E12) | | |
| | | | | | 2019-09 | =COUNTIF($C$2:$C$13, E13) | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment