I need an updated formula to correctly count a total number for me. See the attached sheet.
On the INFO tab, years 2008 and 2011 count correctly. Years 2009 and 2010 are over counting for a total of 6. (4 in 2009 and 2 in 2010). These are highlighted in yellow.
I verified those numbers by filtering the data on the DATA tab and seeing the count. I have verified it as well by using other numbers on my production sheet as well.
What could be causing the count to count incorrectly? Formula or data? Please help!