PlanMaker COUNTP: Legacy Numeric and Logical Counts, with Export Limits

• Introduced: Exact release unknown. The 2010 manual documents COUNTP and its PlanMaker 97 compatibility purpose.
• Availability: Still documented as a legacy compatibility function in PlanMaker 2026; no retirement or final working-version endpoint is established.
• Scope: The reference belongs to the 2026/NX manual family. Individual FreeOffice and mobile-build availability remains unverified.
• Checked: October 14, 2026, against the official reference. Typed examples were independently checked; no native PlanMaker or Excel export test was performed.

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

The first cell range is required; additional ranges are optional. Omit the square brackets in an entered formula. These English examples use commas between arguments.

The official COUNTP entry distinguishes the functions as follows:

COUNT’s own reference also mentions dates and text representing numbers. The short COUNTP page does not define every numeric-text conversion or error case. The comparison below deliberately uses ordinary numbers, plain nonnumeric text, genuine logical values and empty cells.

Create LegacyCount with Entry in A1 and the following data in A2:A9. Enter =TRUE() in A4 so that it is a logical value. Leave A5 and A9 unused, and type N/A as ordinary text.

Enter these formulas outside the input area:

COUNTP includes three numbers and one logical flag. Replacing it with COUNT would reduce this count by one; replacing it with COUNTA would add two text cells. Decide which records should qualify before changing a legacy formula.

On LegacyCount, put Second block in B1. Enter 5 in B2, leave B3 empty, put hold in B4, 17 in B5 and =FALSE() in B6.

B6 contributes one to COUNTP because it holds a logical value. The formula is counting cells of the documented types, not adding the numeric meanings of TRUE and FALSE. The disjoint second range adds three qualifying cells to the first range’s four.

For these controlled input types, a helper column can show the intended test on each row. Put Numeric or logical? in F1. In F2 enter:

=IF(OR(ISNUMBER(A2),ISLOGICAL(A2)),1,0)

Fill F2 through F9. The expected results are 1, 0, 1, 0, 1, 1, 0, 0. Put =SUM(F2:F9) in H2; it gives 4, matching D2.

The helper uses the documented ISNUMBER and ISLOGICAL distinctions. Its purpose is to expose an auditable rule for this fixture. It is not a proven universal COUNTP replacement for every numeric-text, imported-value or error-cell case, and no cross-application save/reopen test is implied.

If your real requirement is simply “count numeric readings,” use COUNT. If it is “count any supplied entry,” use COUNTA. If logical flags must be included but comments excluded, document that rule explicitly and verify representative edge cases before migrating a workbook.

Create VendorCountP with 42 in A1, Test in A2, =TRUE() in A3 and A4 empty. Enter these results in C1:C3:

=COUNTA(A1:A4)
=COUNT(A1:A4)
=COUNTP(A1:A4)

The documented results, in order, are 3, 1 and 2. This small example explains why the three names are not interchangeable.

The official compatibility notice says Excel does not provide COUNTP. When PlanMaker saves a workbook to Excel format, formulas using it are replaced by their current results as fixed values. A displayed result can therefore survive while its recalculating formula is lost. Keep the original PlanMaker workbook and inspect formula preservation before relying on an exported copy.

For an unexpected count, first distinguish actual logical values from text labels, and inspect the selected ranges. The source does not enumerate exact error tokens, overlapping-range deduplication, numeric-text formats or extreme range limits. It also does not establish a final supported release or the availability of every FreeOffice/mobile build.

• COUNT for numeric entries.
• COUNTA for all occupied cells.
• COUNTBLANK for empty positions.
• ISNUMBERP for the related legacy single-cell test and its migration limits.