How to Use the MAXIFS Function in WPS on Windows

This section includes 3 how-to topics for MAXIFS: creating a formula field, checking the argument format, and applying a sample formula; 3 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Create a formula field and call MAXIFS

Entry path: Add Field → Formula

1. Open the multidimensional table where you want to calculate results.
2. Click Add Field on the toolbar.
3. Select Formula as the field type.
4. Enter a formula that includes MAXIFS in the formula editor.
5. Click Confirm and check whether the result appears in the formula field.

Success Criteria

• Interface result: A new formula field appears in the table and shows a calculated result.
• Next action available: You can continue editing the formula or adjusting criteria.

Tips While Using

• Common mistake: If you do not choose the Formula field type, you cannot enter a function formula.
• Environment note: If the online table does not load correctly, check your network connection first.

2. Check the MAXIFS argument format

Entry path: Formula Editor → Function Library → MAXIFS

1. Open the formula editor in your multidimensional table.
2. Open the function library and select MAXIFS.
3. Review the function argument structure.
4. Fill in the target range, criteria ranges, and criteria values as needed.
5. Confirm that each argument matches the intended data type and reference range.

A basic format example is shown below:

MAXIFS(
  [target_range],
  [criteria_range1], [criteria1],
  [criteria_range2], [criteria2]
)

Success Criteria

• Interface result: The formula editor displays the MAXIFS argument structure correctly.
• Next action available: You can continue adding criteria and save the formula.

Tips While Using

• Common mistake: If the target range and criteria ranges do not match correctly, the result may not be what you expect.
• Environment note: Make sure the referenced fields already exist before using them in the formula.

3. Use a sample MAXIFS formula

Entry path: Formula field editor

1. Create or select a formula field.
2. Enter a sample formula such as =MAXIFS(target_range).
3. Add criteria ranges and criteria values based on your business data.
4. Save the formula and review the result.
5. Change the source data and confirm that the result refreshes automatically.

Success Criteria

• Interface result: The formula field returns a maximum value.
• Next action available: When data changes, the result updates accordingly.

Tips While Using

• Common mistake: Using text fields directly in numeric comparisons can produce unexpected results.
• Environment note: If data sync is still in progress, result updates may appear later.