Multiplication, Addition Formula.

[Rye]

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.

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)

 

[AlanY]

this solution with a helper column

Book1
	A	B	C	D
1	Meters	Continuity	Score	Helper
2	0		2	2
3	3	S1	5	110
4	7	S2	6	198
5	9		1	1
6	10		3	3
7	25	F1	5
8	40	F2	6
9
10		Total Score	6+110+198=314	314
Sheet1

Cell Formulas
Range	Formula
D2:D8	D2	=IF(ISBLANK(B2),C2,IF(LEFT(B2,1)="S",C2*(INDEX($A$1:$A$8,MATCH("F"&RIGHT(B2,1),$B$1:$B$8,0))-A2),""))
D10	D10	=SUM(D2:D8)

 

[Rye]

Thank you @AlanY, it works pretty well. I appreciate your quick response.. Cheers

 

[AlanY]

Thank you @AlanY, it works pretty well. I appreciate your quick response.. Cheers

you're welcome