Spreadsheet: 796646d1663416481-sumproduct-total-months-in-a-specific-year-test-version-countif
Sheet: Sheet1

 | 2022 | 1 |  |  |  |  | A01 | 2023-06-26 00:00:00
 |  | 2 |  |  |  |  | A02 | 2023-07-23 00:00:00
 |  | 3 |  |  |  |  | A03 | 2023-06-09 00:00:00
 |  | 4 |  |  |  |  | A04 | 2023-06-16 00:00:00
 |  | 5 |  |  |  |  | A05 | 2023-06-11 00:00:00
 |  | 6 |  |  |  |  | A06 | 2023-06-21 00:00:00
 |  | 7 |  |  |  |  | A07 | 2023-06-14 00:00:00
 |  | 8 |  |  |  |  | A08 | 2023-06-20 00:00:00
 |  | 9 |  |  |  |  | B01 | 2023-04-22 00:00:00
 |  | 10 |  |  |  |  | B02 | 2023-04-18 00:00:00
 |  | 11 |  |  |  |  | B03 | 2023-04-19 00:00:00
 |  | 12 |  |  |  |  | B04 | 2023-04-24 00:00:00
 |  |  |  |  |  |  | B05
 |  |  |  |  |  |  | B06 | 2023-05-12 00:00:00
 | 2023 | 1 |  |  |  |  | B07 | 2023-05-12 00:00:00
 |  | 2 |  |  |  |  | B08 | 2023-04-21 00:00:00
 |  | 3 |  |  |  |  | C01 | 2022-12-23 00:00:00
 |  | 4 |  |  |  |  | C02 | 2023-04-25 00:00:00
 |  | 5 |  |  |  |  | C03 | 2023-02-14 00:00:00
 |  | 6 |  |  |  |  | C04 | 2023-03-05 00:00:00
 |  | 7 |  |  |  |  | C05 | 2022-10-26 00:00:00
 |  | 8 |  |  |  |  | C06 | 2023-03-29 00:00:00
 |  | 9 |  |  |  |  | C07 | 2023-02-17 00:00:00
 |  | 10 |  |  |  |  | C08 | 2023-01-20 00:00:00
 |  | 11 |  |  |  |  | D01 | 2022-10-02 00:00:00
 |  | 12 |  |  |  |  | D02 | 2023-01-14 00:00:00
 |  |  |  |  |  |  | D03 | 2022-11-07 00:00:00
 |  |  |  |  |  |  | D04 | 2022-10-28 00:00:00
 |  |  |  |  |  |  | D05 | 2022-11-10 00:00:00
 |  |  |  |  |  |  | D06 | 2022-10-25 00:00:00
 |  |  |  |  |  |  | D07 | 2022-11-02 00:00:00
 |  |  |  |  |  |  | E01 | 2023-05-22 00:00:00
 |  |  |  |  |  |  | E02 | 2023-04-27 00:00:00
 |  |  |  |  |  |  | E03 | 2023-05-16 00:00:00
 |  |  |  |  |  |  | E04 | 2023-05-22 00:00:00
 |  |  |  |  |  |  | E05 | 2023-05-17 00:00:00
 |  |  |  |  |  |  | E06 | 2023-05-19 00:00:00
 |  |  |  |  |  |  | [NAME] | 2023-05-19 00:00:00
 |  |  |  |  |  |  | E08 | 2023-06-13 00:00:00
 |  |  |  |  |  |  | F01 | 2022-12-10 00:00:00
 |  |  |  |  |  |  | F02 | 2022-12-12 00:00:00
 |  |  |  |  |  |  | F03 | 2022-12-14 00:00:00
 |  |  |  |  |  |  | F04 | 2023-01-23 00:00:00
 |  |  |  |  |  |  | F05 | 2023-05-14 00:00:00
 |  |  |  |  |  |  | F06 | 2022-11-16 00:00:00
 |  |  |  |  |  |  | F07 | 2022-12-18 00:00:00
 |  |  |  |  |  |  | F08 | 2022-11-16 00:00:00
 |  |  |  |  |  |  | G01 | 2023-06-07 00:00:00
 |  |  |  |  |  |  | G02 | 2023-05-26 00:00:00
 |  |  |  |  |  |  | G03 | 2023-05-08 00:00:00
 |  |  |  |  |  |  | G04 | 2023-05-03 00:00:00
 |  |  |  |  |  |  | G05 | 2023-06-03 00:00:00
 |  |  |  |  |  |  | [NAME] | 2023-08-11 00:00:00
 |  |  |  |  |  |  | G07 | 2023-08-11 00:00:00
 |  |  |  |  |  |  | H01 | 2023-09-05 00:00:00
 |  |  |  |  |  |  | H02 | 2023-05-26 00:00:00
 |  |  |  |  |  |  | H03 | 2023-05-31 00:00:00
 |  |  |  |  |  |  | H04 | 2023-06-01 00:00:00
 |  |  |  |  |  |  | H05 | 2023-06-04 00:00:00
 |  |  |  |  |  |  | H06 | 2023-05-29 00:00:00
 |  |  |  |  |  |  | H07 | 2023-08-05 00:00:00
 |  |  |  |  |  |  | H08 | 2023-08-04 00:00:00
 |  |  |  |  |  |  | I01 | 2023-07-18 00:00:00
 |  |  |  |  |  |  | I02 | 2023-07-29 00:00:00
 |  |  |  |  |  |  | I03
 |  |  |  |  |  |  | I04 | 2023-06-27 00:00:00
 |  |  |  |  |  |  | I05 | 2023-07-01 00:00:00
 |  |  |  |  |  |  | I06 | 2023-07-02 00:00:00
 |  |  |  |  |  |  | I07 | 2023-07-08 00:00:00
 |  |  |  |  |  |  | I08 | 2023-08-02 00:00:00
 |  |  |  |  |  |  | J01 | 2023-07-29 00:00:00
 |  |  |  |  |  |  | [NAME] | 2023-07-11 00:00:00
 |  |  |  |  |  |  | J03 | 2023-07-15 00:00:00
 |  |  |  |  |  |  | J04 | 2023-07-07 00:00:00
 |  |  |  |  |  |  | [NAME] | 2023-07-10 00:00:00
 |  |  |  |  |  |  | J06 | 2023-07-17 00:00:00
 |  |  |  |  |  |  | J07 | 2023-07-23 00:00:00
 |  |  |  |  |  |  | J08 | 2023-07-13 00:00:00
 |  |  |  |  |  |  | K01 | 2023-04-06 00:00:00
 |  |  |  |  |  |  | K02 | 2023-04-08 00:00:00
 |  |  |  |  |  |  | K03 | 2023-02-24 00:00:00
 |  |  |  |  |  |  | [NAME] | 2023-08-01 00:00:00
 |  |  |  |  |  |  | K05 | 2023-01-17 00:00:00
 |  |  |  |  |  |  | K06 | 2023-03-14 00:00:00
 |  |  |  |  |  |  | K07 | 2023-02-10 00:00:00
 |  |  |  |  |  |  | K08 | 2023-05-29 00:00:00
 |  |  |  |  |  |  | L01 | 2023-04-09 00:00:00
 |  |  |  |  |  |  | [NAME] | 2023-04-01 00:00:00
 |  |  |  |  |  |  | [NAME] | 2023-04-14 00:00:00
 |  |  |  |  |  |  | [NAME] | 2023-05-03 00:00:00
 |  |  |  |  |  |  | [NAME] | 2023-04-11 00:00:00
 |  |  |  |  |  |  | L06 | 2023-04-14 00:00:00
 |  |  |  |  |  |  | L07 | 2023-06-06 00:00:00
 |  |  |  |  |  |  | L08 | 2023-05-10 00:00:00