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+h...@global.libreoffice.org wrote:
Subject: [libreoffice-users] Calc function COUNTA From: Harvey Nimmo <har...@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+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
