How to use a R1C1 style (Examples)

[wwj]

In a sheet:

Code: Select all

=SUM(R2C11:R4000C11)
- absolute address

For a relative numbering system,
=SUM(R[-5]C[-2]:R[37]C[-2])