# Excel Magic Trick 1283: MINIFS & MAXIFS Excel 2016 Functions: Max or Min with Conditions / Criteria

Video duration: 8:42
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…

## 13 thoughts on “Excel Magic Trick 1283: MINIFS & MAXIFS Excel 2016 Functions: Max or Min with Conditions / Criteria”

(January 11, 2019 - 12:05 am)

Thanks and awesome video

#### Kosta Kondratenko

(January 11, 2019 - 12:05 am)

#### Todd Caywood

(January 11, 2019 - 12:05 am)

I've used Excel for ~10 years, self taught with minimal YouTube help, but your video is great! You found the right medium of not going too fast or too slow. Good job, and thanks!

#### Rakesh Tomar

(January 11, 2019 - 12:05 am)

Thanks i appreciate 😊

#### MrX3room

(January 11, 2019 - 12:05 am)

Thank you, Appreciated.
Could you please tell me? How i can find these formula in 2010 or there is another way?

#### Khurrum Iqbal

(January 11, 2019 - 12:05 am)

Seller = Qty Sold

A = 5
B = 6
C = 8
A = 4
B = 7
C = 6
D = 20
E = 15
A = 5
C = 9
B = 2
E = 5

Q How to sum up the highest/lowest sales quantity achieved by respective salesman.

Highest Total Sales Qty & Name of Seller = ?
Lowest Total Sales Qty & Name of Seller = ?

Using index and match with max and min and sumif or sumproduct?

Please no array formula or helper column, either I don't have MIN IF or MAX IF, I am using Excel 2016 pro plus, 64 bit.

#### Shahmeer Malik

(January 11, 2019 - 12:05 am)

Excel 2016 Pro Plus–I am missing this functions MaxIfs Minifs ?

#### Bill Szysz

(January 11, 2019 - 12:05 am)

Thanks Mike for teaching us. New functions look great!!

#### Laza Lazarevic

(January 11, 2019 - 12:05 am)

Great video, thanx
I just got new formulas 🙂
TEXTJOIN and IFS are just what I need

#### Authorized KJV Stats

(January 11, 2019 - 12:05 am)

Nice work Mike. I love what these new 2016 formulas can do.

#### Forza Algiers

(January 11, 2019 - 12:05 am)

Thank you !!

#### Forza Algiers

(January 11, 2019 - 12:05 am)

Thank you !!

#### Forza Algiers

(January 11, 2019 - 12:05 am)

Than you !!