<< 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: