Weighting Issue

[ScabbyDog]

I'm trying to weight the below formula:

Please Login or Register  to view this content.

So with the value of M95 I want it to only count for 5%, M72 to count for 10%, M51 to count for 17.5%, M28 to count for 27.5% and whatever the vlookup finds to count for 40%. Any ideas on how I can achieve this?

[_Josh_]

Simply mulitply each value by the amount you want to weight it.

=('League Tables'!M95*0.05 + 'League Tables'!M72*0.10 ...

There may be a fancier way with the SUMPRODUCT function if your weights are listed in their own cells.