Avatar

Level 4

I have a complex table which has Totals going across the 12 monthly columns (eg July - Jun) and also has Total going down the rows (eg Total Income).

The formula that I have used for adding the the amounts across the colums is sum(Table20.Row2.Cell[*])  I have renamed majority of the cells to just 'Cell'.  This works perfectly!  My rows are number 1 - 43.

I now have an issue with the formula for adding the amounts going down each row.  I used

sum(Table20

.Row2.Cell,Row3.Cell,Row4.Cell,Row5.Cell,Row6.Cell,Row8.Cell,Row9.Cell,Row10.Cell,Row11.Cell,Row12.Cell,Row13.Cell) in the first cell and it worked perfectly but when I copied across to the other row cells, they all put the same amount in. 

I understand why this has happened, all the cells and named 'Cell' but I don't know if there is an easier way.

Assistance would be greatly appeciated.

Jen