Formula Explanation
 

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

Formula Explanation
 

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" wrote in message
...
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

Formula Explanation
 

And just to add to Vasant's reply:

You can toggle this setting (A1 or R1C1 reference style) in the:
Tools|options|General tab

Kirk wrote:

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

--

Dave Peterson