Hello, so i have a countifs formula, in there i am trying to find the accumulated amount from 2021 to a particular month in 2023, instead of having to change the 2023 month manually for each row, i want the 2023 month to be picked up from Col A instead, but i get an error if i replace "date(2023,8,31) with date(A1), see below formula in Col C:
=COUNTIFS(data44!$M:$M,"A",data44!$D:$D,">="&DATE(2021,1,1),data44!$D:$D,"<="&DATE(2023,8,31),data!$L:$L,"yes")
=COUNTIFS(data44!$M:$M,"A",data44!$D:$D,">="&DATE(2021,1,1),data44!$D:$D,"<="&DATE(2023,8,31),data!$L:$L,"yes")
Col A | Col B | Col C |
2023,8,31 | Aug | 44 |
2023,9,31 | Sept | 67 |
2023,10,31 | Oct | 69 |
2023,11,31 | Nov | 89 |