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?