I have a combine marks sheet of 10 students. some of the student was absent on paper day so I marked them "A" 9absent in the sheet. now I want to equalize the value of A=0 . as it has some impact on average value. i am posting two snapes to clear my point;









Here If I put the value "A" in "4F" average will be "51.13 % in "18F" but if I replace "A" by "0" then average will be "45.44" . I want to show "A" in cell but it value should be considered as "0" in average formula. kindly help...