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 of numbers (like "7")
passed either as arguments or a reference to the cells or as an
array however, empty cells in the reference are not counted.
In your case ISBLANK=0 is seen as Number 2 which is a logical value and
so is counted as 1.
Steve
On 26/06/2022 10:45, Michael D. Setzer II wrote:
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$10000, ISBLANK=0) is getting
0 from range, but 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<[email protected]>
To: libreoffice-users
<[email protected]>
Date sent: Sat, 25 Jun 2022 21:41:23 +0200
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$10000, 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, because a workaround is obvious.
But do I have to mistrust the results of the COUNTA function?
Cheers
Harvey
--
To unsubscribe e-mail to:[email protected]
Problems?https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:https://wiki.documentfoundation.org/Netiquette
List archive:https://listarchives.libreoffice.org/global/users/
Privacy Policy:https://www.documentfoundation.org/privacy
+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor
(Retired)
mailto:[email protected]
mailto:[email protected]
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
