Average If
 

Hi. Is there a way to create a formula that would essentially be an
averageif, similar to a sumif? Thanks!

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!

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!