How to Use the MAXIFS Function in WPS on Windows

Last updated:July 20, 2026

Use MAXIFS through 4 how-to topics, all available without membership; choose a topic from the index and follow the steps to enter, complete, and check the formula.

How-to Index

No.TopicMembership Requirement
11. Enter the MAXIFS functionFree
22. Fill in arguments with syntax guidanceFree
33. Calculate with cross-sheet referencesFree
44. Use MAXIFS in nested formulas with recalculationFree

How-to Guide

1. Enter the MAXIFS function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheet and go to the worksheet where you want the result.
  2. Select the target cell.
  3. Type = in the formula bar or directly in the cell.
  4. Continue by typing MAXIFS(.
  5. Check whether syntax guidance appears in the editing area.

Success Criteria

  • Interface result: The cell enters formula editing mode and shows =MAXIFS(.
  • Next action available: You can continue entering arguments and complete the formula.

Tips While Using

  • Common mistake: If you do not start with =, the content may be treated as plain text.
  • Environment note: This action must be done in an editable spreadsheet cell.

2. Fill in arguments with syntax guidance

Entry point: A cell or formula bar that already contains =MAXIFS(

  1. Enter the range from which you want the maximum value in the first argument position.
  2. Type a comma, then enter the criteria range.
  3. Enter the matching criterion.
  4. If you need more conditions, continue adding criteria ranges and criteria in the same order.
  5. Check the parentheses and separators, then press Enter.

Success Criteria

  • Interface result: The result appears in the target cell.
  • Next action available: When you select the cell again, you can review the full formula in the formula bar.

Tips While Using

  • Common mistake: Mismatched parentheses, incorrect argument order, or missing separators can cause formula errors.
  • Environment note: The criteria ranges and calculation range should be organized consistently for correct results.

3. Calculate with cross-sheet references

Entry point: Target result cell → formula bar

  1. Type =MAXIFS( in the result cell.
  2. Switch to the worksheet that contains the source data and select the maximum-value range.
  3. Return or continue to select the criteria range from the relevant worksheet.
  4. Enter the criterion and complete the closing parenthesis.
  5. Press Enter to finish the cross-sheet calculation.

Success Criteria

  • Interface result: The formula includes worksheet reference information.
  • Next action available: If the source data changes, the result updates accordingly.

Tips While Using

  • Common mistake: Referencing the wrong worksheet or range can produce an unexpected result.
  • Environment note: The related worksheets need to remain in the current workbook.

4. Use MAXIFS in nested formulas with recalculation

Entry point: Target cell → formula bar

  1. Enter a compound formula that includes MAXIFS.
  2. Use MAXIFS as an argument in another function, or reference other cells in its criteria as needed.
  3. Press Enter to view the result.
  4. Change the data or criteria cells used in the calculation.
  5. Check whether the result updates automatically.

Success Criteria

  • Interface result: The compound formula returns a result, and the result changes when the data changes.
  • Next action available: You can continue copying the formula or adjusting the reference ranges.

Tips While Using

  • Common mistake: Text-formatted numbers or circular references can affect the result.
  • Environment note: For complex formulas, review the full expression in the formula bar.