Countifs not calculating as expected
Whenever I change a field to NA it should exclude counting it into the average but it is not doing that. It is staying at 50% but should be 100%. Please let me know what I need to do. See screen shot.
=(SUM(Yes4, Yes6)) / ((COUNT([Department - ie: Sales Eng, TDE's etc]4, [Department - ie: Sales Eng, TDE's etc]6)) - (COUNTIFS(Yes4, "NA", Yes6, "NA")))