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...
PeterBartholomew1 , I didn't catch why do you need helper column. IMHO,
= SUBTOTAL(4,[@amount]) + IFERROR(prior [balance], 0)
shall work (or 9, 109, etc)
Agreed. It was just the way I developed the solution. I should have reduced it to one of your suggested formulas rather just than settling on the first solution that worked. :-(