Download the featured file here: www.bluepecantraining.com/wp-...
In this Microsoft Excel video tutorial I explain how to perform a MEDIANIF calculation, as in a MEDIAN calculation with one or more criteria. Excel does not have a dedicated function for this. I look at three ways you can perform such a calculation in Excel.
🕰️ Timestamps
00:00 Introduction
00:38 Using the MEDIAN & FILTER functions (single criteria)
02:44 Using the MEDIAN & FILTER functions (multiple criteria)
04:39 Using the MEDIAN & IF functions (single criteria)
06:15 Using the MEDIAN & IF functions (multiple criteria)
07:35 Using a PivotTable with the data model (single or multiple criteria)
#exceltips #exceltricks #exceltutorial