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...
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