Excel Magic Trick 1283


MINIFS & MAXIFS Excel 2016 Functions: Max or Min with Conditions / Criteria

DESCRIPTION

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.
(00:13) Discussion of MINIFS & MAXIFS in this video
(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.
(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.

WORKBOOKS

Download “Excel Magic Trick 1281-1300.zip” Excel-Magic-Trick-1281-1300.zip – Downloaded 179 times – 4 MB




Be the first to comment

Leave a Reply