Weighted Score - Assistance

[bdav1216]

Hello,

See the attached spreadsheet.

Columns L, N, P, R, T, V and X have a raw total and have a corresponding weight column. For example, the weight for Column L is Column M.

I would like to create a total weighted score for each associate (in Column K) using the weights that are being applied for each of the raw totals.

Please note that this formula would need to account for '-' values.

If an associate has more than GE 5000 points, output an 'A' in Column L. If an associate has 3000-4999 points, output a 'B' in Column L. If an associate has 1000-2999 points, output a 'C' in Column L, AND under 1000 points, an 'F'.

Please let me know if you have questions, and thank you!

[AliGW]

Please add some expected outcomes to the green cells in your sample workbook.

In the meantime, try this in K3:

=SUMPRODUCT(M3:Y3,N3:Z3)

and this in L3:

=LOOKUP(K3,{0,1000,3000,5000},{"D","C","B","A"})

[bdav1216]

Thank you!
Does this formula account for the '-' values?

I don't have an expected outcome yet for the values. What I am trying to do is weight each of the categories and then use those to create that overall score. I'm open to suggestions though if you think there's a better method to weighting.

[AliGW]

It's up to you to manually check that the results are what you want. I am away from my desk, so use the evaluate formula option on the formulas ribbon to step through and check.