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
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.
ut the counts the isblank=0 as an item?
On 25 Jun 2022 at 21:41, Harvey Nimmo wrote:
Subject:[libreoffice-users] Calc function COUNTA
From: Harvey Nimmo
To: libreoffice-users
Date sent: Sat, 25 Jun 2022 21:41:23 +0200
I wanted t
nts the isblank=0 as an item?
On 25 Jun 2022 at 21:41, Harvey Nimmo wrote:
Subject: [libreoffice-users] Calc function COUNTA
From: Harvey Nimmo
To: libreoffice-users
Date sent: Sat, 25 Jun 2022 21:41:23 +0200
> I wanted to count
I wanted to count the number of non-blank items in a list of items
using COUNTA.
Cell A1 has the formula =COUNTA(A$2:A$1, ISBLANK=0) above an
otherwise empty column. It returns the value 1!
Is that supposed to mean something? Has anyone notice this?
It's obviously not a big problem,