I am trying to create a formula that will automatically sum the last twelve months of data when new months are added (in columns) to the right of the most recent month. Also, don't want to use the "now" feature as information generally lags real time by a couple of months.


Months are columns and the item I want to sum is in the row below the column heading.

Any help would be appreciated.


Submitted via EggHeadCafe - Software Developer Portal of Choice
A Dynamic Progress Bar for Your ASP Page
http://www.eggheadcafe.com/tutorials...ss-bar-fo.aspx