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

From the help COUNTA(Number 1 [; Number 2 [; … [; Number 255]]]) where*Number 1*, *Number 2*, ..., *Number 255* are numbers, references to cells or to cell ranges of numbers.

 * The function counts numbers, dates, error values(Err:502), logical
   values (like TRUE ) or a text representation of numbers (like "7")
   passed either as arguments or a reference to the cells or as an
   array however, empty cells in the reference are not counted.

In your case ISBLANK=0 is seen as Number 2 which is a logical value and so is counted as 1.


On 26/06/2022 10:45, Michael D. Setzer II wrote:
With 3 no blank cells in range
Returns 996
These all return 3

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<>
To:                     libreoffice-users
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?


To unsubscribe e-mail
Posting guidelines + more:
List archive:
Privacy Policy:

  Michael D. Setzer II - Computer Science Instructor
  Guam - Where America's Day Begins
  G4L Disk Imaging Project maintainer

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.