a ongoing 30 day total

[skywriter]

I'm having a hard time wrapping my head around what you want. You have a lot of data and it's hard to understand what you are asking for and where you want to see the results. You have a formula in GU3, but in the code you have written you replace the value in GU3 with the value from another cell. I am willing to help, but you say you download everyday, but where does that data go, you have fixed formulas in some cells, but the code replaces that formula. You say you want cells with formulas to have numbers added to them? Have to think of a way to proceed.