COUNTP (PlanMaker 97 compatibility function)

<< Click to Display Table of Contents >>

COUNTP (PlanMaker 97 compatibility function)

Syntax:

COUNTP(Range1 [, Range2, Range3 ...])

Description:

Counts the number of cells containing numbers or logical values.

Note:

This function was retained only for compatibility with PlanMaker 97. Using the Excel-compatible functions COUNT or COUNTA is recommended instead.

The difference between these three functions is:

COUNTA counts all cells that are not empty (regardless of their content).

COUNT counts only cells that contain numbers.

COUNTP counts only cells that contain numbers or logical values.

Example:

If the cells A1:A3 contain 42, "Test" and TRUE and cell A4 is empty: The following applies:

COUNTA(A1:A4) returns 3

COUNT(A1:A4) returns 1

COUNTP(A1:A4) returns 2

Compatibility notes:

This function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.

See also:

COUNT, COUNTA