Help! please... Automatic update of sub-totals in Excel - TechRepublic
General discussion
November 29, 2009 at 10:52 AM

Help! please… Automatic update of sub-totals in Excel

Apologies if this is a very basic question these days, lol… Can someone please advise the code or formula for Excel 2007 to provide a running total in column D for a list of individual values in column C that updates automatically when values are added to C, but without column D being filled beyond the current row of column C?

So far, i’ve been able to get the running total in D, but it continues to the end of the page, whereas i’d like it to be blank after the latest value, then update immediately when C is increased on the next line. That’d be more presentable, wouldn’t it?

Phew! hope that makes sense! Any help (or reference link)appreciated. Many Thanks!!

This discussion is locked

All Comments