The formula i have is:

Code:

`sFormula = "=SUM(RC[-6]:RC[-1])"`

but is doesn't work for all exercises as some times the total column is "D" or "H"..

what i need is a function like this:

Code:

`sFormula = "=SUM(RC[Number or columns - 1]:RC[-1])"`

Example:

Column: A B C D E TOTAL

NRow 1: 00:00 3 4 5 6 18

NRow 2: 00:05 4 5 9

NRow 3: 00:10 7 9 11 27