Re: [libreoffice-users] Calc function COUNTA

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+help@global.libreoffice.org wrote:
> Subject:
> [libreoffice-users] Calc function COUNTA
> From:
> Harvey Nimmo <harvey@nimmo.de>
> Date:
> 6/25/22, 14:41
>
> To:
> libreoffice-users <users@global.libreoffice.org>
>
>
> 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