Help - Formula To Sum A Dynamic Range

**keithfender** · 03-15-2013, 03:39 PM

Hello again Excel Forum,

Please notice the following table:

Dynamic_Sum_Example.png

Each day as I pull the previous day's info and it is added into the yellow Actuals column, i would like a formula to sum from the first Budget/PY value down to the Budget/PY value that is in the same row as the last (most recent) Actuals value.

Currently I use a simple SUM formula that I manually edit the range everyday. A more flexible formula would be greatly appreciated. FYI, the first workday's values are in row 4.

Thanks in advance,

Keith

**Pepe Le Mokko** · 03-15-2013, 03:51 PM

Nice picture -Please post a sample sheet

**keithfender** · 03-15-2013, 04:15 PM

Sample sheet attached.

Dynamic Sum Formula Sample Sheet.xlsx

Thanks,

Keith

**popipipo** · 03-15-2013, 04:58 PM

Period to Date Actuals:

Please Login or Register  to view this content.

Period to Date Budget:

Please Login or Register  to view this content.

Period to Date PY:

Please Login or Register  to view this content.

Somthing like this?

**keithfender** · 03-18-2013, 09:34 AM

popipipo,

Thank you for those formulas. These are what I was looking for. I also edited this formula to be used in the report for AVERAGEIF as well for daily averages period to date. Very helpful! Thanks again everyone for the quick replies.

Keith