| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum using r1c1 style
Numbers in A1:A5
In C3 I had =SUM(A1:A5) When I switch to R1C1 style this becomes =SUM(R[-4]C[-2]:R[-1]C[-2]) R[-4] means 4 rows above current cell; C[-2] means 2 columns to left of current cell, etc. Any help? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email wrote in message ps.com... How do I sum using the R1C1 reference style? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using INDIRECT & R1C1 Ref style | Excel Worksheet Functions | |||
| R1C1 reference style | Excel Discussion (Misc queries) | |||
| How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
| can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
| R1C1 reference style | Excel Discussion (Misc queries) | |||
Threaded Mode
