Formula Explanation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A co-worker sent me the following formula

=SUM(R[-48]C:R[-1]C

I'm not exactly sure what this means. I am thinking that i tmeans to sum up all of the previous 48 rows, in the previous cell, but I am not positive

Anyone else know what this formula is meant to do?

Any help would be appreciated.

Thanks

Kirk
 
This is relative or R1C1 referencing and yields the sum of the preceding 48
rows in the column containing the formula. C is the same as C[0] and denotes
the same column. R[-1] refers to the row immediately above the row
containing the formula. R[-48] is the row 48 rows above the row containing
the formula.

--

Vasant

Kirk said:
A co-worker sent me the following formula:

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


I'm not exactly sure what this means. I am thinking that i tmeans to sum
Click to expand...
up all of the previous 48 rows, in the previous cell, but I am not positive.
 
And just to add to Vasant's reply:

You can toggle this setting (A1 or R1C1 reference style) in the:
Tools|options|General tab
A co-worker sent me the following formula:

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

I'm not exactly sure what this means. I am thinking that i tmeans to sum up all of the previous 48 rows, in the previous cell, but I am not positive.

Anyone else know what this formula is meant to do?

Any help would be appreciated.

Thanks.

Kirk
Click to expand...
 
Back
Top