Forum Discussion
Tables are fantastic but cumulative totals are a pain
Hi Sam_3026 ,
Yes if you could just post a new item to the community about this that would be great.
@ us in if you like
Cheers
Wyn
Hi, I'm fairly late on this thread and I'm relatively new to Excel tables and structured references. I'm trying to set up a table which handles keeping track of finances for a group. What I'm wondering from reading through this thread is whether there is a consensus position I could take away from this to use in my table. My table has Date, Details, In, Out and Balance, so I would like to use a running total for the Balance field. What would you think might be the best way to set this up, any suggestions?
Dave
I'd go with the N(RowAbove) approach these days to be most flexible
RowAbove is a named reference you create
Thanks for the advice Sergei, my table will only be 1 or 2 thousand rows at the most (for at least a number of years), so I'll go with what I can understand. Much appreciated.
As far as your tables are not at least dozens thousands of rows you may use any approach which is more familiar to you and which you understands better. After that you could start consider performance as the main criteria.
Practically everything in Excel could be done by several ways, abstractly no one of them is better than others, everything depends on concrete situation and goals.
