Grading Matrix

[jrean042]

I need some assistance.
I am trying to set up a grading matrix, based on 5 criteria. In the attached file, there are 5 criteria and what each one is worth.

Ultimately what I am trying to accomplish is a daily grade, and an overall weekly grade.

Any help is appreciated.

[josephteh]

Not sure, but try, in G4, copy down to G10: =IF(B4=""," ",SUM(B4:F4)/4), where 4 is the sum of the maximum value of total score.

In G12: =SUM(B4:F10)/(4*COUNTIF(G4:G10,"<> "))

[jrean042]

This works, but could I make a small edit?
The input values should just be 0,1, but the weights should remain the same (as outlined in the file).
So, each input value is essentially a Yes/No, but some yeses carry more weight than others.

[josephteh]

Will the values for Matrix 5 still 0,-1 or will they now be 0,1?

[jrean042]

It will be 0,1 for No/Yes.

[josephteh]

In G4, copy down: =IF(B4=""," ",SUMPRODUCT(B4:F4,TRANSPOSE($B$18:$B$22)/$B$23))

[jrean042]

@josephteh - Thank you!!

[josephteh]

You are welcome!