I have an excel sheet that is for school budgeting. The even rows list the fall semesters and the odd row list the spring semesters. In the past I was able to use the following formula for moving average of last 5 rows: =AVERAGE(OFFSET(P6,COUNT(P:P)-5,0,5)) This formula won't work now because I need it just to select the even rows and another formula to just select the odd rows.