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

0 votes

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.

Oct 15 in Others by Kithuzzz
• 20,660 points
49 views

1 answer to this question.

0 votes

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".

answered Oct 15 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to stick an embedded document in a specific cell of an excel

Solution Select the documents (you can use the ...READ MORE

answered Oct 18 in Others by narikkadan
• 37,660 points
32 views
0 votes
1 answer

How to use a named column in Excel formulas

Let's say I have the following figures ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
43 views
0 votes
1 answer

Excel VBA : HOW TO PRINT THE TEXT IN A CELL (like Wrap Text)

Use a LineFeed character to create a ...READ MORE

answered Oct 27 in Others by narikkadan
• 37,660 points
67 views
0 votes
1 answer

How to add check symbol in excel cell SXSSFSheet java

Try this: import java.io.FileOutputStream; import org.apache.poi.xssf.streaming.*; class CreateSXSSFUnicode { public ...READ MORE

answered Nov 13 in Others by narikkadan
• 37,660 points
20 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
140 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
236 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
106 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18 in Others by gaurav
• 22,040 points
69 views
0 votes
1 answer
0 votes
1 answer

Absolute worksheet reference in excel cell formulas

Try this: =INDIRECT("Sheet1!C"&ROW()) READ MORE

answered Oct 10 in Others by narikkadan
• 37,660 points
52 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP