WPS Features
Resources
Free AI Tools
Docs Center

How to Use the MINIFS Function in WPS on Windows

Last updated:July 13, 2026

Use the MINIFS function in WPS with 3 how-to topics, including 3 free topics and 0 membership-related topics, and jump to each task from the How-to Index.

How-to Index

No.TopicMembership Requirement
11. Insert MINIFS from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Check the syntax and parameter detailsFree

How-to Guide

1. Insert MINIFS from the Insert Function dialog

Entry: Formulas tab → Insert Function, or the fx button in the formula bar

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
  3. Search for MINIFS in the dialog box.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog box.
  6. Click OK to finish inserting the function.

Success Criteria

  • The selected cell now contains the MINIFS function.
  • A calculation result appears after the parameters are completed.
  • The formula can be edited further or copied to other cells.

Tips While Using

  • Keep the criteria ranges aligned with the minimum-value range to avoid unexpected results.
  • Use English punctuation for formula separators.

2. Type the formula directly in a cell

Entry: a worksheet cell or the formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =MINIFS(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to review parameter hints, watch the formula prompt after typing the opening parenthesis.

Success Criteria

  • The cell displays a calculation result.
  • The full MINIFS formula is visible in the formula bar when the cell is selected.
  • The formula can be copied, edited, or filled down.

Tips While Using

  • Confirm the referenced ranges before entering the formula.
  • When filling the formula across cells, check relative and absolute references.

3. Check the syntax and parameter details

Entry: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Search for MINIFS.
  3. Select the function and review the syntax: MINIFS(min_range, criteria_range1, criteria1, ...).
  4. Open the related help entry if you need more detail about the parameters.

Success Criteria

  • You can see the MINIFS function name and syntax structure.
  • You can distinguish the minimum-value range, criteria ranges, and criteria arguments.
  • You can continue entering the formula or troubleshooting errors with the syntax reference.

Tips While Using

  • Syntax review is useful when you use the function for the first time or when you need to troubleshoot an error.
  • If the result is not what you expect, check the parameter order and referenced ranges first.