Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a way to average if in excel when looking at a range of d
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. |
#2
|
|||
|
|||
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
excel moving average | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |