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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Average If... 12
Average range of discontinuous cells 1
Average IF 3
Averaging two ranges on the same column (excluding zeros) 2
Average Ranges of Cells, Return Separate Value for Each Range 5
Average of select range of numbers 2
Using STDEV to evaluate a subset of a population 6

Back
Top