File: https://excelisfun.net/files/EMT1283-1285.xlsx

Download File: https://excelisfun.net/
Learn how to use the MINIFS & MAXIFS functions to find the Minimum and Maximum values in a column based on one or more conditions or criteria.

1. (00:13) Discussion of MINIFS & MAXIFS in this video
2. (01:13) MINIFS and MAXIFS calculation with one condition / criteria. Find the Minimum and Maximum values in a column based on one condition. See Relative and Absolute Cell References.
3. (04:17) MINIFS and MAXIFS calculation with two condition / criteria. Find the Minimum and Maximum values in a column based on two conditions or criteria. See Relative and Absolute Cell References.

Purchase "Office 2016 for Office 365" https://products.office.com/en-us/buy/office
Go to Office Insider site to download "Office Insider Version" https://products.office.com/en-US/office-insider
Office Insider Version: 16.0.6568.1011 or 16.0.6568.2025