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