That is no surprise to me.
ISBLANK=0
is non-sensical and returns "#NAME?". COUNTA counts
that as a non-empty value. All is good.
Mike
On 6/25/22 15:05, users+h...@global.libreoffice.org wrote:
Subject:
[libreoffice-users] Calc function COUNTA
From:
Harvey Nimmo
Date:
6/25/22, 14:41
To:
Thanks for all the inputs! Great stuff.
As I said, I wanted to count the number of non-blank cells in a column,
but as =COUNTA(A$2:A$1, ISBLANK=0) is above an otherwise empty
column returns the value 1, I am obviously not using the function
correctly. =COUNTA(A$2:A$1) does the trick.
From the help COUNTA(Number 1 [; Number 2 [; … [; Number 255]]])
where*Number 1*, *Number 2*, ..., *Number 255* are numbers, references
to cells or to cell ranges of numbers.
* The function counts numbers, dates, error values(Err:502), logical
values (like TRUE ) or a text representation
With 3 no blank cells in range
=COUNTBLANK($A$2:$A$1000)
Returns 996
These all return 3
=COUNTA($A$2:$A$1000)
=COUNTIF($A$2:$A$1000,">""")
=COUNTIFS($A$2:$A$1000,">""")
Believe =COUNTA(A$2:A$1, ISBLANK=0) is getting
0 from range, but the counts the isblank=0 as an item?
On 25 Jun 2022 at