Using the MAXIFS Function (Practical Example)
To contact me: [email protected]
Complete Excel Training Courses:
► Mastering Power Query - From Beginner to Pro: https://www.videodecompta.com/maitris...
► Designing Excel Applications with VBA: https://www.videodecompta.com/formati...
► From Intermediate to Expert in Excel: https://www.videodecompta.com/de-moye...
Accounting Training Courses to Develop Your Career
► Managing the Year-End Closing Process: https://www.videodecompta.com/maitris...
► Accounting Manager: https://www.videodecompta.com/devenir...
___________________
Video Notes: I was working on a project in Excel when the expected results required calculating a maximum and a minimum, each dependent on two conditions. To be honest, it's the first time I've faced such a challenge. Generally, in my work, when it comes to determining a maximum or a minimum, the constraint of criteria to consider doesn't arise.
Luckily, Microsoft has thought of almost everything. After doing some research, I was pleased to discover that a dedicated function exists: MaxIFS for the maximum and MinIFS for the minimum. I tested it and saw that it works perfectly.
I wanted to share this with you.
To download the presentation template, click on the following link:
https://www.videodecompta.com/utilise...
To access a free Excel training course, click on the following link: • Formation EXCEL pour COMPTABLES DEBUTANTS
To visit the website: https://www.videodecompta.com/