Learn More:- https://www.exceltutorial.net/

🧑‍🏫 Statistical Functions Playlist:- https://youtube.com/playlist?list=PLhvn6aQRdimWkjAu5tBtC37DayKJ_mWg1

In this video, we will use the MAXIFS function to find the maximum value in a range of cells based on one or more criteria.

The MAXIFS function is very useful for finding the maximum value in a range of cells, and it can be used in a variety of different ways. In this video, we will demonstrate how to use the MAXIFS function to find the maximum value in a range of cells based on one or more criteria.

We will also show you some practical examples of how to use the MAXIFS function in Excel.

Table of Content;

00:00 Introduction

00:23 MAXIFS Function in Excel

06:00 Conclusion

Now lets see and understand the syntax of MAXIFS function in excel;

=MAXIFS(max_range, criteria_range, criteria)

The arguments of the MAXIFS function are as follows:

Max_range – This is the range of cells that you want to find the maximum value in.

Criteria_range – This is the range of cells that you want to apply the criteria to.

Criteria – This is the criterion that you want to use to find the maximum value in the max_range.

Other Playlists:-

Financial Functions in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimU1umiFNnQrVugsq_TJ6LDD

Cell References in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVC65nzr2BebSN9kPSdK6qH

Logical Functions in Excel :- https://youtube.com/playlist?list=PLhvn6aQRdimWBCKHNrLEqubXDMaHeINU1

Count and Sum Functions in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVHQA5zqrJ6XG6e5jP5hyQN

Learn Data Validation In Hindi: https://youtube.com/playlist?list=PLhvn6aQRdimXirM12gw1eijuiMYta-Oqf

Learn Excel Tutorials Online:- https://www.youtube.com/playlist?list=PLhvn6aQRdimWKL2jOmJxQBEBTeIzmx-zW

Excel Analysis Tutorial: https://youtube.com/playlist?list=PLhvn6aQRdimUhgO4q3gJWiz4QrbSVGmIz ... https://www.youtube.com/watch?v=qMK5jlH7zNg