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