top of page

MAXIFS AND MINIFS FUNCTIONS

The MAXIFS function enables us to identify the maximum value within a range while considering specific criteria.

By utilizing MAXIFS, we can simultaneously evaluate multiple conditions across multiple ranges.

The syntax of the MAXIFS is: =MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ….)

  1. max_range – This is the range where we want to return the maximum value (based on criteria defined in the following part of the function)

  2. criteria_range1 – This is the range in which we will check our criteria

  3. criteria1 – This is the criteria to be checked.

  4. [optional] criteria_range2 – This is the second range in which we will check our criteria.

  5. [optional] criteria2 = This is the second criteria to be checked

The MINIFS function facilitates the identification of the minimum value within a range, taking into account specific criteria.

With MINIFS, users can conveniently assess multiple conditions across multiple ranges simultaneously.

The syntax of the MINIFS is: =MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ….)

  1. min_range – This is the range where we want to return the minimum value (based on criteria defined in the following part of the function)

  2. criteria_range1 – This is the range in which we will check our criteria

  3. criteria1 – This is the criteria to be checked.

  4. [optional] criteria_range2 – This is the second range in which we will check our criteria.

  5. [optional] criteria2 = This is the second criteria to be checked

We can use the following operators within MAXIFS and MINIFS function:

> Greater than

< Less than

<= Less than or equal to

>= Greater than or equal to

<> Not equal to

bottom of page