# MAXIFS

## Content

This function returns the maximum value among the values in cells or the cell range provided the specified set of conditions or the criteria meets.

## Syntax

`MAXIFS(max_range, range1, criteria1, [range2,criteria2], ...)`

## Arguments

This function has the following arguments:

| Argument | Description |
| -------- | ----------- |
| *max\_range* | [Required] Refers to the range of cells in which maximum will be calculated |
| *range1* | [Required] Refers to the set of cells to be calculated based on the criteria |
| *criteria1* | [Required] Refers to the criteria (in terms of number, expression, or text) according to which cells will be calculated |
| *range2, criteria2...* | [Optional] Refers to the additional ranges and their corresponding criteria. You can enter up to 126 range/criteria pairs. |

## Remarks

If the size and shape of *max\_range* and *rangeN (refers to range1,2,3,4,......N) arguments* is not same, this function will return the #VALUE! error.
If cells do not match with the specified criteria, this function will return 0.

## Examples

`MAXIFS(C4:C7,B4:B7,"325")` gives the result 656
`MAXIFS(C4:C7,B4:B7,"55")` gives the result 0