percentage weight

[Guest]

I am teacher trying to make a grading program that can give a different
percentage weight for various tasks and account for missing marks from
students who are absent for an assignment. I am using this formula that I
found from some other excel genius:
=SUMPRODUCT($D$3:$X$3,D17:X17)/SUMIF(D17:X17,"<>",$D$3:$X$3). This works
fine if there isn't a formula in D17:X17 like a test result average formula
e.g. D7/D2. This seems to screw up the formula. Any ideas?

Here is an example of what I mean:
A B C D E
1 total points out of 40 30 20
2 percent weight 15% 25% 60% Overall average
3 student A's mark 30 24 18
4 student B's mark 20 blacnk 15 (formula above pointing to
otherfields that divide B4/B1 etc)

I hope someone understands what I'm getting at. Please help. THANKS!

 

[Bob Phillips]

I just tried re-creating this as I understand what you say, and I didn't get
a problem, it returned a valid answer.

Do you want to send me your spreadsheet and I will take a look at it.

 

[fpdiab]

I would love to send you the file. My email address is
(e-mail address removed).

Thanks for your interest.

Fadi

 

[Guest]

I would love for you to see the file. My email address is (e-mail address removed)