I need help configuring a formula for running total. I'm not sure if this is even possible, but let's see! Say I have two columns- one labeled "daily production" and the other "monthly production". Is there a way for the daily production to update the monthly production column each time there is a number put in without having more columns? For example, if 200 was put in a cell in the daily production column, the monthly production would be updated to 200. Then the next day, say we do 300. We update the daily production cell from 200 to 300, then monthly production would be 500. Is this a possible formula?
2 Answers
If you don't want to go with vba as Scott Craner described, you can try to do kind of similar thing with Smart Tables. The good thing about those tables is they adjust automatically so the formulas are adjusted as well
As far as I know, you can't save and calculate previous data by formula alone.
I recommend you use PivotTable, you just need to simply record the daily production, the PivotTable monthly production data can be automatically updated.
#Yury Suturin
, and another should, useDaily Inputs
and go forGroup & SubTotal
, group onMonth
and get Subtotal forValue Entry
. BUT what you have described in your post above isRUNNING SUM
and yes it's possible,, if U are looking for it, just confirm through comments, will help us to fix it.