Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index

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:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.