Adding numbers if several conditions are true

[Goauld]

Hello,
I'm making a video game were some objects can have 1 or several improvements that have effect their statistics.
I'm trying to calculate the statistics of my objects if 1 or several improvement are true (available for the player). If one improvement is true, then it's true for all the objects.

In my example attached, I have 3 different train that have different speed. You can put 2 speed improvement on them.
If one improvement is true, then the improvement value and the train value are added.

My problem is that I can check if one value is true and make the calculation, but I have no idea how to do it for a huge database. Any solution I can think of give me wrong results

Tanks For your help!

[AliGW]

Please explain in detail your expected speed results.

[Goauld]

Ok sorry!

In my example, the first train has 80 speed.
The first improvement gives 10 speed.
The second improvement gives 30 speed

If the player has no improvement, the speed stays at 80
If the player has only the first improvement, the final result is 90
If the player has only the second improvement, the final result is 110
If the player has the first and second improvement, the final result is 120

[AliGW]

Player?

There are no players defined on your sheet.

How do we know if the invisible player has the first, second or both improvements? Where is that indicated?

[Goauld]

It's in the table B14 - B 15.
If a improvement is true, I put a 1 (meaning the player has it). If a improvement is false (player doesn't have it), I put a 0.
The final result is expected in the table "Improvement Simulation", in the orange cells (C9 - C11)

I simulate only 1 player at the time, so I put the datas needed manually in B14 - B15

[SAI80]

Try using in cell C9

=C3+sumproduct($B$14:$B$15;$J$3:$J$4)

Is this what you needed?

[Goauld]

SAI80. Yes it's working! I could even do just =C3+$B$14*$J$3+$B$15*$J$4
I feel stupid now XD

Thanks!