This how-to guide includes 4 topics, all available without membership; use the How-to Index to jump to the task you need and follow the entry point and steps.

How-to Index

#	Topic	Membership
1	1. Enter the MINIFS function	Free
2	2. View syntax prompts and fill in arguments	Free
3	3. Use cross-sheet references in a calculation	Free
4	4. Use MINIFS inside a nested formula	Free

How-to Guide

1. Enter the MINIFS function

Entry point: Formulas tab → formula bar

Open WPS AirSheet and select the cell where you want to show the result.
Type = in the formula bar or directly in the cell.
Continue by typing MINIFS(.
Get ready to enter the min range and criteria arguments.

Success Criteria

UI state: The current cell enters formula input mode and shows =MINIFS(.
Next actions: You can continue entering arguments and complete the calculation.

Tips While Using

Common mistakes: If you do not type = first, the content may be treated as plain text.

2. View syntax prompts and fill in arguments

Entry point: formula bar

After typing MINIFS(, view the syntax prompt shown by the app.
Enter the min range, criteria ranges, and criteria values in order.
Check that parentheses, commas, and range references are complete.
Press Enter to confirm the formula.

Success Criteria

UI state: The cell shows a calculation result.
Next actions: You can select the cell again to review or edit the formula.

Tips While Using

Common mistakes: Missing arguments, unmatched parentheses, or incorrect separators can cause formula errors.

3. Use cross-sheet references in a calculation

Entry point: formula bar

Select the target cell and type =MINIFS(.
In the arguments, switch to another sheet and select the min range or criteria range you want to reference.
Return to the current sheet and complete the remaining arguments.
Press Enter to finish the cross-sheet calculation.

Success Criteria

UI state: The formula includes sheet references and returns a normal result.
Next actions: If you change data in the referenced sheet, the result updates accordingly.

Tips While Using

Common mistakes: Incomplete ranges or the wrong sheet name can affect the result.

4. Use MINIFS inside a nested formula

Entry point: formula bar

Select the target cell and type the outer formula you need.
Insert MINIFS( into one of the outer formula arguments.
Fill in the MINIFS arguments by following the syntax prompt.
Complete the outer formula and press Enter.

Success Criteria

UI state: The cell returns the final result of the nested formula.
Next actions: You can continue adjusting inner and outer arguments in the formula bar.

Tips While Using

Common mistakes: When the nesting level becomes deeper, it is easier to miss parentheses or use the wrong references.