Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average with Conditions
I am using the following formula to calculate the average sales for a
specific point in time and it works However when I close the sheet and reopen it and then update the values it returns and #Value error until I open up the source sheet. Is there a way to avoid this? -- ce "Paul C" wrote: In Excel 2007 there is a AVERAGEIF function (look it up in help) that should do the trick =SUMIF(Sheet1!B9:B39,"<=" & B10,Sheet1!AE9:AE39)/COUNTIF(Sheet1!B9:B39,"<=" & B10) -- If this helps, please remember to click yes. -- ce |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating an average with conditions. | Excel Discussion (Misc queries) | |||
Average with multiple conditions | Excel Worksheet Functions | |||
AVERAGE with conditions | Excel Worksheet Functions | |||
Using AVERAGE with conditions in different worksheets? | Excel Worksheet Functions | |||
average on 2 conditions | Excel Worksheet Functions |