=AVERAGE(IF((rng1100)*(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)
"Aaron" wrote in message
...
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.
|