View Single Post
  #3   Report Post  
Posted to microsoft.public.word.tables
Ngan
 
Posts: n/a
Default Cell referencing in table formulas - just ONE adjacent cell

Hi Greg,
Thanks for your response. Sorry I failed to mention that I tried this
method and even though it works, I can't copy this formula down the column
since the cell references are absolute. That means I have to manually modify
each cell to SUM(a1, 1), SUM(a2, 1), SUM(a3, 1) etc... and it's a pain when
you have a lot of cells to fill ...
I guess my question is more hypothetical than practical - if you can't have
relative cell referencing in Word, are there not any keywords to reference
adjacent cells besides ABOVE, BELOW, LEFT, and RIGHT?
Thanks much again!
-ngan

"Greg Maxey" wrote:

All tables cells have a reference. A1 is the first cell in the top
left corner. B1 is to its right and A2 is below it.

Just enter the cell reference of the cell above your cell holding the
formula. For example, if you have a 5 by 5 table and want the formula
in cell C3 then enter {=Sum(C2,1)}