CODEWITHSUNDEEP
excelformula
user11239160
user11239160

Reputation: 3

Understanding there is no "MedianIFs" function, is there a formula work around?

Essentially, I need a formula like "averageifs" to find median

I need the median of H:H if A:A="Example", if C:C = B1

This is my Averageifs for context. 

=AVERAGEIFS(Promo!$H$2:$H$1269,Promo!$A$2:$A$1269,PSheet!$B10,Promo!$C$2:$C$1269,PSheet!$B$1)

Any help will be truly appreciated!!

Upvotes: 0

Views: 5400

Answers (1)

Scott Craner
Scott Craner

Reputation: 152475

Use an array formula:

=MEDIAN(IF((Promo!$A$2:$A$1269=PSheet!$B10)*(Promo!$C$2:$C$1269=PSheet!$B$1),Promo!$H$2:$H$1269))

Being an array formula it must be confirmed with Ctrl-Shift-Enter instead of Enter when exiting edit mode.

Upvotes: 2

Related Questions