I am trying to the write the formula to sum up a row. My last column always varies but the first column is fixed. .
The formula i have is:
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:
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
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