Excel Forum



Mr Excel & excelisfun Trick 55: Calculate Grade & Exclude Scores When Student Is Absent.


See Mr Excel and excelisfun use SUMPRODUCT, ISNUMBER, and SUMIF functions to calculate a grade where excused absences are considered in final grade.





Got a Question? Ask it Here in the Forum.