|
<< Click to Display Table of Contents >> COUNTP (PlanMaker 97 compatibility function) |
Syntax:
COUNTP(Range1 [, Range2, Range3 ...])
Description:
This determines how many cells in one or more ranges are filled with numbers or logical values.
Note:
This function was retained only for compatibility with PlanMaker 97. If possible, use the Excel-compatible functions COUNT and COUNTA instead of this function.
The difference between these three functions is as follows:
COUNTA counts all cells that are not empty (regardless of their content).
COUNT counts all cells that contain numbers.
COUNTP counts all cells that contain numbers or logical values.
Example:
Let's assume that 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 does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current result as a fixed value.
See also: