This tutorial example uses a MEDIAN IF array formula to find the middle tender for two different projects. The nature of the formula allows us to search for multiple results by simply changing the search criteria (in this tutorial example, the project name).
Learn how to calculate a simple median and median in Excel with two or more criteria. (Quick Start Guide)
The job of each part of the formula is:
Array formulas are created by pressing the Ctrl+Shift+Enter keys on the keyboard simultaneously after typing the formula. Because of the keys pressed to create the array formula, they are sometimes called CSE formulas.
The syntax and arguments for the MEDIAN IF formula are as follows:
