Excel - Can I Use It To Automate Math Tasks? 2

[maybeimaleo]

I'm not very fluent in formulas and the like, but I have been hoping to automate some tasks for a long time. I just do not know where to begin.


I calculate scores for a free fantasy formula1 grand prix and, quite frankly, I am tired of doing it manually!

This is how the spreadsheet is setup:

It lists the drivers, manufacturers, and engines and who scored points for a given GP. Below this is a list of all of the teams and their selections (two drivers, one chassis [aka - mfg's], an engine, and a bonus GP, where all points are doubled).

What I want to do is this:

Type in the drivers, chassis, and engine in a cell, then put the points in a different cell, for example:
cell a,1: vettel cell b,1: 25
cell a,2: webber cell b,2: 18
So on and so forth for drivers, chassis, and engine.
Then I want to write code that will take the driver's/chassis'/engine's name and basically do a find/replace - find the drivers name in a,1 and replace it with the contents of b,1.
Once that is done I want to add the numbers for each team, doubling the number for anyone with a bonus GP, then sorting all teams but the total points column.

I would also like to enumerate the teams (1,2,3,4,4,4 if tied, etc..) and eventually I would like to find a way to take this sheet and add it will others so that I could automate the addition , sorting, and enumerating the overall standings.

Can anyone help steer my in the right direction?
I am sorry that this is long, but any help in the right direction would be a HUGE help for me.

Thanks!

 

[maybeimaleo]

ok, thanks!

I add each GP together to get an overall score for the Overall Leader-board.

Does that make sense?

 

[SkipVought]

Use the SUM function, referencing the range, rather than adding each reference.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}