Formula Explanation

[Kirk]

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

 

[Vasant Nanavati]

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

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.

 

[Dave Peterson]

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