Sonia Bowditch
asked on
Simple Formula using COUNTIFS
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much.
ASKER