how to find weightage of a percentage score

aarosh

New Member
Joined
Jun 27, 2007
Messages
5
Hi,

I am not sure how to explain this. Let me put this in simple terms. I have three areas where an employee is scored a percentage score. Say for employee A could be reviewed 10 times in process 1 and he could score 90% on it, could be reviewed 2 times in process 2 and be scored 80% on it, and could be reviewed 20 times in process 3 and be scored 50%. I want 50% of the scores of process 1, 40% scores of process 2 and 10% scores of process 3. how do i go about getting the final scores based on these weightages?

Thanx
aarosh.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Code:
Test          : A   B   C
Weights       : 50% 40% 10%
Times Reviewed: 4   3   1
Score         : 80% 90% 60%

From the best of my understanding you want:
(4*.8*.5+3*.9*.4+1*.6*.1)/7
So that a more reviewed test is also weighted more?

If this is the case than use Sumproduct in the following way

Code:
SUMPRODUCT(A$2:C$2,A3:C3,A4:C4)/SUM(A3:C3)

If you don't want the number of times a test has been taken to factor in simply use
Code:
SUMPRODUCT(A$2:C$2,A4:C4)[code]

HTH,
~GoldFish
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top