Please let me thank you all for your effort in solving some formulas recently. Appreciate it much.
I just have the last formula to ask to complete my table, but if it's not gonna work in this case, it will be totally fine. Please see the situation below.
I just have the last formula to ask to complete my table, but if it's not gonna work in this case, it will be totally fine. Please see the situation below.
Meters | Continuity | Score | |
0 | 2 | ||
3 | S1 | 5 | |
7 | S2 | 6 | |
9 | 1 | ||
10 | 3 | ||
25 | F1 | 5 | |
40 | F2 | 6 | |
Total Score | 6+110+198=314 | ||
This will be my last missing formula to complete my table. But if we don’t have possible solution, it's fine. | |||
Is there any way to get the sum of Column C? But the situation is the value of S1 will be multiply by Meters where F1 is located. | |||
Ex. Continuity S1(5) * 22 (Meters (3-25)) =110 | |||
5*22=110 | |||
Continuity S2(6) * 33 (Meters (40-7))=198 | |||
6*33=198 | |||
S1 means Start, and F1 means finish. S1 always ends in F1, same as S2 always ends in F2. | |||
Please note as well that S1, S2 and F1, F2 are always changing cell position in Column C (Score) | |||