General discussion


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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Is there any code for this?


Thanks for reading, best wishes to you.

Collapse -

sorry man i have no clue i rarely use excel

by RookieTech In reply to Is there any code for thi ...
Collapse -


Thanks anyway, Rook. It's many years since i used excel and i'm just trying to pick it up again to make p/l numbers more accessible in my new bit of biz.

Collapse -

same here

by RookieTech In reply to Cheers......

Related Discussions

Related Forums