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




About this tutorial:

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

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

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

    Birendra Prasad Sah

    (January 11, 2019 - 12:05 am)

    Thanks and awesome video

    Kosta Kondratenko

    (January 11, 2019 - 12:05 am)

    Love your videos!

    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 !!

Leave a Reply

Your email address will not be published. Required fields are marked *