Contact
12 programs
Explore the site

COUNT Function (OpenOffice Calc)

Statistical Beginner OpenOffice Calc Introduction not established

The COUNT function in OpenOffice Calc counts numeric values in a range. Learn syntax, examples, common errors, and best practices.

Verification status: Consult the documentation, examples and any stated test scope below. How formula examples are checked

Availability and version history

  • Introduced: Documented by Apache OpenOffice 4.1.16; original introduction not established.
  • Availability: Supported in Apache OpenOffice 4.1.16, verified against its function registry. This identifies a supported release, not a final working version.
  • Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
  • Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.

The COUNT function in OpenOffice Calc counts the number of numeric values in a range. It ignores text, empty cells, logical values, and errors, making it ideal for analyzing datasets where only true numeric entries matter. Whether you’re counting transactions, quantities, measurements, or any numeric dataset, COUNT is one of the most fundamental statistical functions in OpenOffice Calc.

What the COUNT Function Does

  • Counts numeric values only
  • Ignores text, empty cells, and logical values
  • Works across sheets
  • Handles large datasets efficiently
  • Useful for validating data completeness
  • Ideal for statistical and analytical workflows

COUNT is the foundation for many data‑quality checks and numeric analyses.

Syntax

COUNT(value1; value2; ...)

Arguments:

  • value1, value2, … — Individual values, cell references, or ranges
COUNT ignores text, empty cells, and logical values such as TRUE/FALSE.

Basic Examples

Count numeric values in a range

=COUNT(A1:A10)

Counts how many cells in A1:A10 contain numbers.

Count numbers across multiple ranges

=COUNT(A1:A10; C1:C10)

Count numbers mixed with text

If A1:A5 contains: 10, "Text", 5, "", 20:

=COUNT(A1:A5)

Result: 3

Count numbers in a list of values

=COUNT(5; 12; "Hello"; 99)

Result: 3

Advanced Examples

Count numbers across sheets

=COUNT(Sheet1.A1:A100)

Count numbers while ignoring filtered rows

Use SUBTOTAL instead:

=SUBTOTAL(2; A1:A100)

Function code 2 = COUNT.

Count numbers with conditions (COUNTIF)

=COUNTIF(A1:A100; ">50")

Count numbers with multiple conditions (COUNTIFS)

=COUNTIFS(A1:A100; ">0"; B1:B100; "<100")

Count numbers excluding zeros

=COUNTIF(A1:A100; "<>0")

Count numbers in a 3D range

=COUNT(Sheet1:Sheet5.A1:A10)

Counts numeric values across multiple sheets.

Common Errors and Fixes

COUNT returns 0 unexpectedly

Possible causes:

  • Numbers stored as text
  • Hidden apostrophes ('123)
  • Imported CSV values not converted to numbers
  • Cells formatted as text

Fix: Convert text to numbers:
Data → Text to Columns → OK

COUNT includes values you expected it to ignore

COUNT includes:

  • Dates (because dates are stored as numbers)
  • Times (also numeric)

COUNT excludes values you expected it to include

COUNT ignores:

  • Text numbers ("123")
  • Empty cells
  • Logical values (TRUE/FALSE)
  • Errors

Err:504 — Parameter error

Occurs when:

  • A malformed range is used
  • A semicolon is missing
  • A text argument is not quoted properly

Err:508 — Missing parenthesis

Usually caused by:

  • Missing )
  • Using commas instead of semicolons

Best Practices

  • Use COUNT only for numeric data
  • Use COUNTA when counting non‑empty cells
  • Use COUNTBLANK to count empty cells
  • Use COUNTIF/COUNTIFS for conditional counting
  • Convert imported text numbers to real numbers
  • Use named ranges for cleaner formulas
If you need to count all non‑empty cells, use COUNTA.
If you need to count only empty cells, use COUNTBLANK.