What is the MAXIFS function?
The MAXIFS function is a new function in Excel 2016, used to find the largest value that satisfies a given condition
Learn more at Microsoft Support.
Usage
The function: MAXIFS returns the smallest value that satisfies one or more given conditions.
Follow the following example:
I applied the function MAXIFS to filter out the highest score among the girls.
Range D3:D17 is score, range C3:C17 contains gender, I condition this range to match female.
The result is 10.0.
How to use
Formula:
=MAXIFS(max_range, criteria_range1, criteria1, criteria_range2, criteria2,...)
- Max_range: The data range to find the highest value.
- Criteria_range: The area where the condition needs to be set.
- Criteria: The condition.
Notice:
- The function only applies to Excel versions from 2016 or later, see instructions for installing Excel 365 here.
- Does not distinguish uppercase or lowercase characters.
- You can use wildcard characters like * or ?.
- The max_range and criteria_range coordinates must coincide to avoid the #Value! error.
Above is an article on how to use te function MAXIFS in Excel.
Wish you success in applying to work or study!
Combining sheets together using VBA
Instructions to combine Excel sheets with the same columns into one using VBA
Create a snow effect with HTML and CSS
Decorate your blog with snow effect with Tuan to welcome the coming Christmas season.
Insert images automatically with VBA
Instructions for inserting images automatically for Excel with VBA, the most detailed and easy to do.
