Is there a way to average if in excel when looking at a range of d

A

Aaron

Is there a way to average if in excel when looking at a range of data. For
example, I want average a subset of numbers in a list based on those numbers
in that list that are above a certain threshold as well as are in a subset of
another criteria in another column. All of this without adding an additional
column.
 
B

Bob Phillips

=AVERAGE(IF((rng1>100)*(ISNUMBER(MATCH(rng1,rng2,0))),rng1))

which is an array formula, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top