Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula explanation | Excel Discussion (Misc queries) | |||
formula explanation | Excel Discussion (Misc queries) | |||
Would like an explanation of a formula: | New Users to Excel | |||
FORMULA EXPLANATION | New Users to Excel | |||
Formula Explanation Please | Excel Discussion (Misc queries) |