I think I understand....
IF...The Cumulative Weight Pct can be different for each student (based on
whether they have a score for a particular item), then try this:
Copy those formulas down for each student.
HOWEVER...if the Cumulative Weight Pct is static for ALL students and
each pct is only used when ANY student has a score for that category,
then: I'd put Effective Weight Pct formulas under each Weight Pct to
determine if it's used or not:
Then you can use your original formulas, but reference $AU$10, instead of $AU$9.
Does that help?
Bookmarks