0

I am having problem with countifs. So I have a data. In this case, I am trying to countif how many things in year 1, year 2 and year 3 are 2017 and matching it with count of yr 1, yr 2 and yr 3. In this case 2017 was in year 1, year 2 and year 3. So, I am not sure how to connect the year 1, year 2, year 3 to yr 1, yr. 2 and yr 3. So the answer is 2. It is 2 because 2017 number for yr 2 was not reported in the second row.

CY Year 1 Year 2 Year 3 Yr 1 Yr 2 Yr 3
2014 2015 2016 2017 55 58 57
2015 2016 2017 100
2016 2017 57

Any help is greatly appreciated!

(Visited 15 times, 1 visits today)