Calculate base on dynamic columns

[minhhieule89]

I have a table similar like below, I want to do a formula so that depends on the value of the first row (T1, T2 or T3) it will take the corresponding value and subtract the Date column then sum the total value.


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Date[/TD]
[TD]T1[/TD]
[TD]T2[/TD]
[TD]T3[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1/1/2017[/TD]
[TD]7/1/2017[/TD]
[TD]8/1/2017[/TD]
[TD]9/1/2017[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1/1/2016[/TD]
[TD]7/10/2017[/TD]
[TD]8/15/2017[/TD]
[TD]9/10/2017[/TD]
[/TR]
</tbody>[/TABLE]

 

[mart37]

do you mean this: =SUMPRODUCT(C2:E2-B2)