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, 2022 in Others by Kithuzzz
• 38,010 points
580 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, 2022 by narikkadan
• 63,420 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, 2022 in Others by narikkadan
• 63,420 points
397 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, 2022 in Others by narikkadan
• 63,420 points
303 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, 2022 in Others by narikkadan
• 63,420 points
734 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, 2022 in Others by narikkadan
• 63,420 points
468 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, 2022 in Others by Edureka
• 13,670 points
1,235 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, 2022 in Others by Edureka
• 13,670 points
1,420 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, 2022 in Others by Edureka
• 13,670 points
697 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
2,327 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,420 points
3,044 views
0 votes
1 answer

Absolute worksheet reference in excel cell formulas

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

answered Oct 10, 2022 in Others by narikkadan
• 63,420 points
353 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