MAXIFS Function

This function returns the largest value in a list or array of numbers that satisfy multiple conditions.

Syntax: MAXIFS(max_range, criteria_range1, criteria1 [,criteria_range2, criteria2] [..])

• max_range: The actual cells to the max.
• criteria_range1: The range of cells you want to be evaluated.
• criteria1: The expression that contains the criteria.
• criteria_range2:  The range of cells you want to be evaluated (Optional).
• criteria2: The expression that contains the criteria (Optional).

To Utilize this Function:

• Click the Insert function dialog box on the Formulas tab.

• Enter MAXIFS in the “Search for a Function” dialog box, then click the GO button and select OK.

• The delimiter, ignore_empty, and text1 dialog boxes will appear; enter the text and click OK.

A formula is a mathematical expression that computes a cell’s value. Functions are predefined formulas found in Excel. Based on the values specified as arguments or parameters, functions perform specific calculations in a specific order. For instance, =SUM (C1:C10). This function adds the values from cells C1 to C10. In the math and trigonometry, statistical, engineering, date and time, lookup and reference, logical, and text function categories, several new functions are added. In addition, the Web category is introduced, along with a few Web service features. Some Basic functions in Excel were discovered earlier that can be used to perform basic operations.

We also have a Statistical function in Excel that can be used in industries and businesses for better and more effective results.