I have a column that contains ten cells that will have a score of 100, 0 or the words “No Impact” in them. I need excel to average this column but exclude the cells that contain the words “No Impact”. So basically, if I take 10 tests and score 100 on all of them but 1, how do I get excel to average 100 by forgiving one of those test that I would be labeled “No Impact”)?</SPAN>
100 – test one</SPAN>
100 – test two</SPAN>
100 – test three</SPAN>
100 – test four</SPAN>
100 – test five</SPAN>
100 – test six </SPAN>
No Impact – test seven</SPAN>
100 – test eight</SPAN>
100 – test nine </SPAN>
100 – test ten </SPAN>
Average should return 100% not 90%</SPAN></SPAN>
100 – test one</SPAN>
100 – test two</SPAN>
100 – test three</SPAN>
100 – test four</SPAN>
100 – test five</SPAN>
100 – test six </SPAN>
No Impact – test seven</SPAN>
100 – test eight</SPAN>
100 – test nine </SPAN>
100 – test ten </SPAN>
Average should return 100% not 90%</SPAN></SPAN>