Re: [libreoffice-users] Calc function COUNTA

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