MAXIFS Function (LibreOffice Calc)
Learn the MAXIFS function in LibreOffice Calc: Returns the maximum value in a range that meet multiple criteria in multiple ranges.
The MAXIFS function in LibreOffice Calc is used for this task: Returns the maximum value in a range that meet multiple criteria in multiple ranges. Find the largest amount in rows meeting a category condition.
This guide explains how to read the formula, reproduce a concrete example, interpret its result and recognize common input mistakes.
Syntax and arguments
MAXIFS(max_range; range; criteria)
| Argument | Required? | Meaning |
|---|---|---|
Max range |
Yes | The range from which the maximum will be determined. |
Range |
Yes | Range 1, range 2,… are the ranges to be evaluated by the criteria given. |
Criteria |
Yes | Criteria 1, criteria 2,… are the criteria to be applied to the ranges given. |
Calc formulas normally use semicolons (;) between arguments in common configurations; the displayed separator may depend on settings or locale.
Worked example
Use this small practice sheet for the ranges referenced in the formula:
| Row | A (Quantity) | B (Amount) | C (Category) |
|---|---|---|---|
| 1 | 1 | 10 | apple |
| 2 | 2 | 20 | pear |
| 3 | 3 | 30 | apple |
| 4 | 4 | 40 | pear |
| 5 | 5 | 50 | apple |
=MAXIFS(B1:B5;C1:C5;"apple")
Expected result: 50.
Why it works: Find the largest amount in rows meeting a category condition. The specified sample table supplies the referenced cells.
How to use it in your own spreadsheet
- Identify the cells or inputs that correspond to the sample values above.
- Enter the formula in an empty cell, changing the references or literal values to match your sheet.
- Compare the output with a manual check on a small known example.
- Extend the formula to a larger dataset only after you understand the result.
Common problems and practical checks
- Confirm that the data represents the intended sample, population, rate or cash-flow timing.
- Keep units and percentage conventions consistent; a mathematically valid result can still answer the wrong question.
- A pasted formula may produce an error when it uses the other program’s argument separator or unsupported options.
Related functions
Documentation and verification
- LibreOffice Calc Help
- The standalone example was calculated using LibreOffice Calc 25.2.3.2 on October 9, 2026 and its computed result matched the expected value. This does not certify every option, version, or other example.