Set formula to ignore blank cells
Hiya. Like Anim8me2 (good question about using formulas to assign letter grades to ranges of values), I am building a grade book for teaching. I really want to get away from my clunky and inelegant gradebook program and should be able to if I can solve this one remaining problem:
THE PROBLEM: My sheet has rows of students with their scores on various assignments listed across in columns. (I set the point value of each assignment separately.) I've got Total and % columns to compute each student's points earned/points possible. This works great when every student is responsible for all assignments, but occasionally students are exempt from some items. How, therefore, can I build a formula that will sense when a cell is empty and adjust down the points possible value accordingly?
Here's a sample of my sheet. How do I make Chaucer's total points figure only on those assignments he's completed (as 48/49 instead of 48/69)?
THE PROBLEM: My sheet has rows of students with their scores on various assignments listed across in columns. (I set the point value of each assignment separately.) I've got Total and % columns to compute each student's points earned/points possible. This works great when every student is responsible for all assignments, but occasionally students are exempt from some items. How, therefore, can I build a formula that will sense when a cell is empty and adjust down the points possible value accordingly?
Here's a sample of my sheet. How do I make Chaucer's total points figure only on those assignments he's completed (as 48/49 instead of 48/69)?
PowerBook G4, Mac OS X (10.4.10)
