COUNTA
Supported, behaves as documentedCategory: Statistical · Last tested 2026-07-04
Support matrix
| Engine | Documented | Live-tested | Verdict |
|---|---|---|---|
| Excel | Yes | Not yet | n/a |
| Google Sheets | Yes | Not yet | n/a |
| LibreOffice Calc | Yes | Yes (24.2.7.2, 2026-07-04) | Supported, behaves as documented |
Executed test cases
LibreOffice Calc 24.2.7.2 (tested 2026-07-04)
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =COUNTA(A1:A6) | COUNTA counts every non-blank cell regardless of type: numbers, text, and booleans all count, unlike COUNT which only counts numbers (same setup as COUNT_mixed_types_range) | 4 | 4 A1, A2, A4, A5 are all non-blank (A3, A6 are genuinely blank and excluded) |
Matched |
| =COUNTA(A1:A2) | A cell holding a formula that returns "" is still counted by COUNTA, because it contains content (a formula), even though it displays as empty. Confirmed via Microsoft's COUNTA docs (https://support.microsoft.com/en-us/office/counta-function-7dc98875-d5c1-46f1-9a82-53f3219e2509): "if the range contains a formula that returns an empty string, the COUNTA function counts that value." | 2 | 2 Both A1 (formula returning "") and A2 (5) are counted; this same A1 cell is ALSO counted as blank by COUNTBLANK - see COUNTBLANK_empty_string_formula_counted_as_blank |
Matched |
| =COUNTA(A1:A5) | A range with no content at all counts as 0 | 0 | 0 | Matched |
Docs & syntax
- Excel: official documentation
- Google Sheets: official documentation
- LibreOffice Calc: official documentation