Link to home
Start Free TrialLog in
Avatar of agwalsh
agwalsh

asked on

Excel tables, running totals, automatic update of formula

hi Folks
Got asked this question the other day. I've attached a file with a sample...essentially it has a running total formula in it..but is there any way to set up the formula so that it will automatically add on the row above i.e. automatically update if rows are inserted?
EE---automatic-running-total.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of agwalsh
agwalsh

ASKER

no, it was just a straight question...based on that one. Let me try the Rgonzo option first... thanks :-)
Avatar of agwalsh

ASKER

Did exactly what was required...as per rgonzo1971 solution.thanks.