Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average If
Hi. Is there a way to create a formula that would essentially be an
averageif, similar to a sumif? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average If
=SUMIF / COUNT IF
or =AVERAGE(IF(...)) entered as an array formula. Dave -- Brevity is the soul of wit. "Steph" wrote: Hi. Is there a way to create a formula that would essentially be an averageif, similar to a sumif? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average If
You can set up an array formula to do this. Essentially, it would take
the form: =AVERAGE(IF((condition_1)*(condition_2)*(condition _3),range_to_average)) Your conditions may be things like (A1:A10<0), or (B1:B10100) etc, and your ranges should cover the same number of cells. The asterisks act like AND to enable you to string a number of conditions together. You need to commit the formula using CTRL-SHIFT-ENTER (CSE) instead of the normal ENTER, and if you do this correctly then Excel will wrap the formula within curly braces { } when viewed in the formula bar - do not type these yourself. Hope this helps. Pete Steph wrote: Hi. Is there a way to create a formula that would essentially be an averageif, similar to a sumif? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rolling average | Excel Worksheet Functions | |||
Modified Average Function | Excel Worksheet Functions | |||
plotted Average | Charts and Charting in Excel | |||
What is this kind of average called? | Excel Worksheet Functions | |||
average function in Excel 2002 | New Users to Excel |