[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]OIGINAL AMOUNT[/TD]
[TD]REV1[/TD]
[TD]REV2[/TD]
[TD]REV3[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]50[/TD]
[TD]100[/TD]
[TD]150[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]100[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]300[/TD]
[TD]800[/TD]
[TD]300[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]150[/TD]
[TD]30[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]60[/TD]
[TD]30[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]f[/TD]
[TD]11[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]
I need a formula to sum all based on the latest value entered from the example above it will pick up
200 for row a
50 for row b
300 for row c
50 for row d
50 for row e
7 for row f
total should be 657
thank you very much
<tbody>[TR]
[TD][/TD]
[TD]OIGINAL AMOUNT[/TD]
[TD]REV1[/TD]
[TD]REV2[/TD]
[TD]REV3[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]50[/TD]
[TD]100[/TD]
[TD]150[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]100[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]300[/TD]
[TD]800[/TD]
[TD]300[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]150[/TD]
[TD]30[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]60[/TD]
[TD]30[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]f[/TD]
[TD]11[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]
I need a formula to sum all based on the latest value entered from the example above it will pick up
200 for row a
50 for row b
300 for row c
50 for row d
50 for row e
7 for row f
total should be 657
thank you very much