MrExcel Publishing
Your One Stop for Excel Tips & Solutions

accumulate values in a single cell

Posted by Peter on January 21, 2002 4:40 PM

I wish to show a Month to Date $ value in a single cell using daily input of production hours x $ rate.
I used simple formulae to achieve the daily total but am stumped on how to add it to the previous days total.

Posted by Jacob on January 21, 2002 5:14 PM


Lets say the running total is in A1 and the current days total is in B1 then

Sub MyMacro()

range("A1").formulaR1C1 = range("A1").value + range("B1").value

end sub