Re: [libreoffice-users] Calc function COUNTA

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<harvey@nimmo.de>
> To:                     libreoffice-users
> <users@global.libreoffice.org>
> 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:users+unsubscribe@global.libreoffice.org
> > 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:mikes@guam.net                             
>   mailto:msetzerii@gmail.com
>   Guam - Where America's Day Begins
>   G4L Disk Imaging Project maintainer
>   http://sourceforge.net/projects/g4l/
> +------------------------------------------------------------+

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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