COUNT Function (OpenOffice Calc)
The COUNT function in OpenOffice Calc counts numeric values in a range. Learn syntax, examples, common errors, and best practices.
Compatibility
▾| Excel | ✔ |
| Gnumeric | ✔ |
| Google_sheets | ✔ |
| Libreoffice | ✔ |
| Numbers | ✖ |
| Onlyoffice | ✔ |
| Openoffice | ✔ |
| Wps | ✔ |
| Zoho | ✔ |
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
If you need to count only empty cells, use
COUNTA.If you need to count only empty cells, use
COUNTBLANK.