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 <har...@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+unsubscr...@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:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- To unsubscribe e-mail to: users+unsubscr...@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