WPS Features
Resources
Free AI Tools
Docs Center

How to Use

Last updated:July 8, 2026

Use COUNTA through 3 how-to topics: inserting it from the Insert Function dialog, typing the formula directly, and checking syntax guidance; 3 topics are available without membership and 0 are membership-related.

How-to Index

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

How-to Guide

1. Insert COUNTA from the Insert Function dialog

Entry point: Formula 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 Formula tab.
  3. Search for COUNTA in the Insert Function dialog.
  4. Select the function and click OK.
  5. Enter each required parameter in the Function Arguments dialog.
  6. Click OK to finish inserting the formula.

Success Criteria

  • The selected cell now contains a COUNTA formula.
  • After the parameters are confirmed, you can return to the worksheet and review the result.

Tips While Using

  • Search with the standard function name COUNTA for faster results.
  • Separate parameters with English commas.

2. Type the formula directly in a cell

Entry point: Target cell or formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =COUNTA(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm the formula.
  4. If you want to review parameter guidance, type =COUNTA( and press F1 to open syntax help.

Success Criteria

  • The cell shows a calculated result instead of unfinished text.
  • When you select the cell, the full formula is visible in the formula bar.

Tips While Using

  • Start the formula with an equals sign.
  • If you use non-English punctuation for separators, the formula may not calculate correctly.

3. Check function syntax and parameter guidance

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter COUNTA in the search box.
  3. Select the function to review the syntax COUNTA(...).
  4. Click the help link for that function to open more details.

Success Criteria

  • You can see the COUNTA function name and syntax structure.
  • You can continue entering parameters and return to the worksheet to use the formula.

Tips While Using

  • Opening detailed help may require an internet connection.
  • Confirm the reference range before final entry to reduce result mismatches.