- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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
Views
Replies
Total Likes