MAXIFS
The MAXIFS function returns the maximum value from a range of cells that meets multiple criteria. Use this function to find the highest value in a dataset based on specified conditions.
Syntax 🔗
=MAXIFS(Max_range, Criteria_range1, Criteria1, [Criteria_range2, Criteria2,...])
Max_range | The range of cells from which you want to find the maximum value. |
Criteria_range1 | The range of cells that contain the first set of criteria. |
Criteria1 | The criteria that must be met in Criteria_range1. |
Criteria_range2 | Criteria2, ..., Additional ranges and criteria sets you want to apply. |
Note: | You can provide up to 127 range/criteria pairs in MAXIFS. |
About MAXIFS 🔗
Use the MAXIFS function to find the highest value in a range that meets one or more criteria. This function helps you target the maximum value based on specific conditions, useful for analyzing datasets like budgets or sales figures. Set your criteria to get precise results tailored to your needs.
Examples 🔗
Suppose you have a dataset that includes sales figures for different regions and months. You want to find the highest sales amount for the 'East' region in the month of 'January'. Use the MAXIFS formula: =MAXIFS(Sales_range, Region_range, "East", Months_range, "January"). This returns the maximum sales value that meets both conditions.
Imagine you have a table with student scores for various subjects and you wish to determine the highest score obtained by a student named 'Alice' in 'Math' and 'Science'. Use the MAXIFS formula: =MAXIFS(Scores_range, Names_range, "Alice", Subjects_range, "Math", Subjects_range, "Science"). This provides you with Alice's highest score across both subjects.
Notes 🔗
Use the MAXIFS function to specify multiple criteria sets for identifying the maximum value in a dataset. Ensure your criteria references and ranges are correctly aligned to achieve accurate results.
Questions 🔗
You can provide up to 127 range/criteria pairs in the MAXIFS function, enabling you to apply a wide range of criteria to pinpoint the maximum value in your dataset.
Can the MAXIFS function handle non-numeric criteria for finding the maximum value?Yes, the MAXIFS function can handle both numeric and non-numeric criteria. You can specify text, dates, logical values, or any other type of criteria to filter the dataset and find the maximum value that meets your specified conditions.
Is MAXIFS case-sensitive when evaluating criteria?Yes, MAXIFS is case-sensitive when evaluating criteria. Ensure that your criteria match the case of the data in your dataset to obtain accurate results.