Apr 17 2022 10:08 AM
I have a column with many dates, such as: 10/01/22, 05/04/23, etc. I have another column with text names. I want the total number of matches for a specific text " " that have a 2022 associated date. I then want to do the same thing but for 2023. The date field column has the the full date and not just the year.
Apr 17 2022 10:23 AM
SolutionApr 17 2022 10:36 AM
Apr 17 2022 10:23 AM
Solution=SUMPRODUCT(($B$2:$B$23=E2)*(YEAR($A$2:$A$23)=D2))
Maybe with this formula.