Hi

I have 30 months of data (from Sep 2005 to Dec 2007) laid out in columns.
Rows are different names of employees.

I want to create averages for the each year from Sep to Aug so I that in the
end of August there would be Sep 05 to Aug 06 average, Sep 06 to Aug 07
average, Sep 07 to Aug 08 average.

I'm referencing the current month, previous month, and the YTD in a table.
For example, I would have Dec 2007, Nov 2007, and Sep 07-Aug 08 data.

I want to be able to change it so that if I want to see Dec 2006 data, I
would get Dec 2006, Nov 2006, and Sep 06-Dec 06 and not Sep 06-Aug 07 in the
table.

I thought I could use lookup and average but I also have blank cells in my
spreadsheet which shouldn't be accounted for in the formulae.

Thanks