Forum Discussion
Tables are fantastic but cumulative totals are a pain
Excel Tables have too many benefits to list here, if you've never used them then check out my article here
Tables = Ctrl +T
One frustration I do have though is that cumulative totals...
This is great stuff!
I have been struggling with references in tables to cells in previous rows. I have always used normal cell reference and that worked because in those particular cases I do not need to insert rows in the middle of the table or even sort the table. This tip of yours will be very useful in the future.
Thank you for sharing this!
Glad to help :)
