Need Macro and/or Formula to produce a "cummulative to date" value

[michaeljoeyeager]

Friends,

Please see the image and let me know if it is possible to have a formula that will add the value of the cell to the left of the selection to the next non-empty cell above it?

fdsa.png

I assume that I will need a macro to get it done... How would I go about it? The left column is a "consumed material" column and the right is a cummulative "to date" column but there are not always consumptions everyday so there will be a varying number of cells between "consumed material" inputs...

I can't seem to figure out how to fully automate the cummulative running total... Thanks in advance for the help!

-Mike








Is it possible to have a formula that will add the value of the cell to the left of the selection to the next non-empty cell above it?

[Ace_XL]

Use

For Row 1 use =If(A1="","",SUM($A$1:A1))
For Row 2 use =If(A2="","",SUM($A$1:A2))

and so on

[michaeljoeyeager]

Haha...

I feel dumb... That was a lot easier than I thought it would be... Sometimes you can't see the simple solution because you have convinced yourself it will take a complex one...

Thanks ACE