Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average is dependent on conditions
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average is dependent on conditions
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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average is dependent on conditions
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" wrote: 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average is dependent on conditions
Upload & post a direct link to your sample**
You could use: http://www.freefilehosting.net/ **desensitize it as appropriate -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to average with conditions attached | Excel Discussion (Misc queries) | |||
Average with multiple conditions | Excel Worksheet Functions | |||
AVERAGE with conditions | Excel Worksheet Functions | |||
Conditional Average (2 conditions) | Excel Worksheet Functions | |||
average on 2 conditions | Excel Worksheet Functions |