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. |
=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. |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com