Average is dependent on conditions

[forest8]

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

 

[Max]

Perhaps you could post a direct link to your sample

You could use:
http://www.freefilehosting.net/


Btw, not sure whether it's related to this posting,
but I've just responded to you in your earlier thread:
http://tinyurl.com/2egxn4


---

 

[forest8]

No it's not. That one refers to a rolling average.

I have 20 months of data. 8 months from 2006 and 12 months from 2007 in the
same file.

I'm using hlookup based on the selected month. Based on this number, I want
to see the YTD based on the Year.

If I'm looking at December 2006, I want to see December 2006 data, November
2006 Data, and May to Dec 2006.

If I'm looking at June 2007, I want to see June 2007, May 2007, and Jan to
June 2007.

Based on the selected month, I want to see a different YTD figure.

 

[Max]

Upload & post a direct link to your sample**
You could use:
http://www.freefilehosting.net/
**desensitize it as appropriate

---