https://support.microsoft.com › en-us › office › maxifs-function-dfd611e6-da2c-488a-919b-9b...
MAXIFS function - Microsoft SupportThe MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria. Note: This feature is available on Windows or Mac if you have Office 2019, or if you have a Microsoft 365 subscription .
https://exceljet.net › functions › maxifs-function
Excel MAXIFS function | ExceljetThe Excel MAXIFS function returns the largest numeric value in cells that meet multiple conditions, referred to as criteria. To define criteria, MAXIFS supports logical operators (>,<,<>,=) and wildcards (*,?,~), and can apply conditions to cells that contain dates, numbers, and text.
https://www.ablebits.com › office-addins-blog › excel-max-if-formula
Excel MAX IF formula to find largest value with conditions - AblebitsMAX IF formula examples to get the max value in Excel based on one or several conditions that you specify.
https://fr.extendoffice.com › excel › functions › excel-maxifs-function.html
Comment utiliser la fonction Excel MAXIFS - ExtendOfficeL'Excel MAXIFS La fonction renvoie la plus grande valeur d'une plage de valeurs qui a spécifié un ensemble de critères. Syntaxe et arguments. Syntaxe de formule. MAXIFS (plage_maximale, critères_plage1, critères1, [critères_plage2, critères2], ) Arguments.
https://support.microsoft.com › fr-fr › office › max-si-ens-max-si-ens-fonction-dfd611e6-da2...
MAX.SI.ENS (MAX.SI.ENS, fonction) - Support MicrosoftLa fonction MAXIFS retourne la valeur maximale parmi les cellules spécifiées par un ensemble donné de conditions ou de critères : nombres, dates, texte, etc. Cette fonctionnalité est disponible sur Windows ou Mac si vous avez Office 2019, ou si vous avez un abonnement Microsoft 365.
https://www.ablebits.com › office-addins-blog › maxifs-function-excel-multiple-criteria
MAXIFS function in Excel – find max value with multiple criteriaThe MAXIFS function returns the largest numeric value in the specified range based on one or more criteria. The syntax of the MAXIFS function is as follows: MAXIFS (max_range, criteria_range1, criteria1, [criteria_range2, criteria2], …) Where: Max_range (required) - the range of cells where you want to find the maximum value.
https://exceljet.net › formulas › maximum-if-multiple-criteria
Maximum if multiple criteria - Excel formula | ExceljetTo get the maximum value in a set of data that meets multiple criteria, you can use a formula based on the MAXIFS function. In the example shown, the formula in H5 is: = MAXIFS (data [Value], data [Group],F5, data [Temp],"<" & G5) With "A" in cell F5 and the number 73 in cell G5, the result is 88.
https://exceljet.net › formulas › max-if-criteria-match
Max if criteria match - Excel formula | ExceljetThe Excel MAXIFS function returns the largest numeric value in cells that meet multiple conditions, referred to as criteria. To define criteria, MAXIFS supports logical operators (>,<,<>,=) and wildcards (*,?,~), and can apply conditions to cells that contain dates, numbers, and text...
https://coefficient.io › excel-tutorials › maxifs
Using The MAXIFS Function In Excel [Step-by-Step Guide ... - CoefficientThe ‘MAXIFS’ function in Excel is designed to return the maximum value in a range based on one or more conditions. Here’s a detailed guide on how to use the ‘MAXIFS’ function with a single criterion, including a practical example.
https://www.exceltutorial.net › how-to-use-maxifs-function-in-excel
How to Use MAXIFS Function in Excel (With Examples)The MAXIFS function in Excel is a powerful tool that allows you to find the maximum value based on one or more criteria. In this tutorial, we will be using this function to find the topper female and male students in a class.