| Author |
Message |
|
TheVision
|
Post subject: Right, Who’s good with spreadsheets?  Posted: Tue Apr 21, 2009 8:46 |
|
| SupaMod |
 |
| "Praisebot" |
Joined: 30th Mar, 2008
Posts: 17099
Location: Parts unknown
|
|
The attached spreadsheet is something I’m doing for work and I haven’t got a clue how to do what I’m supposed to do? The yellow boxes should each be a score out of 5 culminating in a score out of 25 in the grey box underneath. Now, this is the hard part… the red box underneath should then be a % score BUT the scores out of 5 should be weighted towards the final score. The weightings are to the left. This is the thing that I can’t get my head around.
So.. Would anyone like a go and see if they can help me out and do some formula for me? I haven’t got a clue where to start.
You do not have the required permissions to view the files attached to this post.
|
|
| Top |
|
 |
|
Joans
|
Post subject: Re: Right, Who’s good with spreadsheets? Posted: Tue Apr 21, 2009 8:55 |
|
Joined: 31st Mar, 2008
Posts: 8655
|
|
Well your score out of 25 would simply be =sum(c3:c7) - and repeat for each column
And you just need to factor each score up to its percentage, so in C9 put
=c3*5 + c4*5 + c5*6 + c6*2 + c7*2
and that should give you a weighted percentage.
|
|
| Top |
|
|
|
TheVision
|
Post subject: Re: Right, Who’s good with spreadsheets? Posted: Tue Apr 21, 2009 9:04 |
|
| SupaMod |
|
| "Praisebot" |
Joined: 30th Mar, 2008
Posts: 17099
Location: Parts unknown
|
And it works!! Thanks loads Joans!  Just what I needed!
|
|
| Top |
|
|
Register
Calendar
FAQ
Search