I have been struggling with this and it is driving me nuts. I haven't used this formula before I would really appreciate if someone could point out where I am going wrong.
Formula COUNTIFS(IDs when Year = Year and the week no matches the year)
Test Data:
ID YEAR WEEK COUNT
3 2009 22
18 2009 22
13 2009 33
12 2010 22
4 2010 29
5 2011 33
11 2011 56
20 2012 1
14 2013 33
15 2013 33
16 2013 33
6 2013 55
10 2013 55
2 2015 4
8 2015 7
1 2016 5
9 2016 7
19 2016 39
7 2016 56
17 2016 56