Re: [libreoffice-users] Calc function COUNTA

At 12:59 26/06/2022 +0200, Harvey Nimmo wrote:
> As I said, I wanted to count the number of non-blank cells in a 
> column, but as =COUNTA(A$2:A$10000, ISBLANK=0) is above an otherwise 
> empty column returns the value 1, I am obviously not using the 
> function correctly.

Indeed: as explained.

> =COUNTA(A$2:A$10000) does the trick.

Actually, not so. That formula counts the number of non-*empty* cells 
in the specified range. What I (and probably others) thought you were 
looking for was what you said: a count of non-*blank* cells. If you 
have, say, text in some cells in the range but some cells not empty 
but containing a blank or blanks, then COUNTA() will reckon up the 
blank cells as well, and you need a different formula (as suggested) 
to ignore those along with any empty cells.

But I'm glad you are happy with what you have, of course.

Brian Barker  



--
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