Excel calculate the Median IF - two methods | Function and PivotTable

I love the Median Function in Excel, but I want to use it conditionally. For example, I want to calculate the median salary of the Accounting department, or what is the median price of homes in Atlanta, GA?
If you want the average, Excel has AVERAGEIF, but there is no MEDIANIF in Excel. In this video, I will show two methods of calculating the Median IF. I'll also use the COUNT function and FORMULATEXT function plus the status bar to test.

Chapter:
0:00 Intro
0:30 AverageIF function
2:20 FormulaText function
2:40 Median & If Function
3:23 Test results
4:40 COUNT function
5:40 Issue with Median and IF
7:10 Create a Pivot Table

#chrismenardtraining #msexcel #exceltraining

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[rosegu]

Thanks so much for your kind sharing, Chris! Saved a ton of timing by leveraging this self-made function in pivot table!

[hmtheog]

Best answer on this, especially with larger datasets. None of the other solutions via google search work. Thanks!

[tah-seen]

So far the best video I got on YT. Thank you so much

[haleycollingwood]

This was a fantastic tutorial!! Exactly what I needed.

[martharobinson]

Wow! This is an awesome video, it certainly had me subscribing. Thank you Chris

[anarihan]

Hey Chris, Thank you for this video. This really helped me. I am in the midst looking for a job as data analytics. One of the assessments is to find the median of some data. I was struggling using Median if formulas then your video popped up when I search "how to" and it works magically... Thank you...

[suewhitehead]

This was an excellent tutorial. Trying to do medians on salaries has always been such a pain so I am thrilled to have learnt something new. Have bookmarked this page so I can come back to it

[gonearpana]

Thank you so much sir, the second method is a life saver.

[prakritiii]

Thank you so much for such a great tutorial

[yesterdaytodaytomorrow]

Hi Chris, thanks a lot for this video. I've got one question regarding 8:05 - when I drag the column to Values tab, it shows Count only and not Sum with message showing can't show Sum as the column is in text format.. quite weird cause my excel data is all in numbers. Could you help on that please? Thanks.

[JohnSmith-cfnx]

Can you calculate the median of a column where two criteria have to be met. Say median of the sales where linked in is the source and single family was also true

[jeffgoblue]

Great video. What was the necessity/purpose of turning you data field into a Table first before doing the PivotTable. PT recognizes the range whether it's a table or not. Thanks!!

[roywilson]

Nice video. It is amazing what can be done with the data model and a smattering of DAX code.

[pipo]

how about in Median in column (running median) based on dates and other conditions?

[niralipatel]

I am trying to add measure to table but table is not showing under pivot table . What i see is directly Column names

[DenyseWhiting]

Can you tell me how I would do it if the data in column E were numbers instead? Ex.: LinkedIn=1, Google Ads=2, Meta=3.