How to express absolute cell references in Excel R1C1-style formulas

Question

I want to use a fixed start cell in a range for a SUM function.

I'm working with XSLT 1.0 where I create this:

<Cell ss:StyleID="s76" ss:Formula="=SUM(K6:R[-1]C)">
    <Data ss:Type="Number"/>
</Cell>

But the formula appears in Excel as =SUM('K6':K19), and an error message pops up "The formula contains the unrecognized text".

I have tried this:

=SUM(R[-14]C:R[-1]C)

But this is not a good option, because the range can be changed.

Answer 1

If the formulas are in Column K and you want to refer to "K6," you would use the R1C1 reference style with R6C ("row 6, same column").

So for a range, this:

=SUM(R6C:R[-1]C)

Would mean "row 6, same column -to the previous row, the same column".