I have an equation that uses the averageifs function:
=AVERAGEIFS(A:A, B:B, 1)
What would be the equivalent function if I wanted to take the median as opposed to the average, while still maintaining the conditional parameters the averageifs statement allows?
Last edited by dforte; 04-11-2012 at 12:38 PM.
A formula I've found to work for this basic case is as follows, but must be entered as an array (ctrl+shift+enter):
=MEDIAN(IF(A:A=1, B:B))
Thanks All!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks