Crizznitch
Board Regular
- Joined
- Nov 18, 2004
- Messages
- 120
Howdy, I am inputting monthly data and need to take the average of the last 12 months that have been entered (over a two-year time period max and the first year is already completely entered). However, at the end of the first year there are two rows that sum and average the data from year 1, and then a blank row.
I was wondering if there is a formula, or a way to piece together a formula, that will take the last twelve months as I am entering the data from the months this year and ignore the SUM and AVG rows. I currently have a formula that ignores the blank row, but not the other two rows.
I was wondering if there is a formula, or a way to piece together a formula, that will take the last twelve months as I am entering the data from the months this year and ignore the SUM and AVG rows. I currently have a formula that ignores the blank row, but not the other two rows.