2022 Archives by date, by thread · List index

# Re: [libreoffice-users] Calc function COUNTA

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.
```
Steve

On 26/06/2022 10:45, Michael D. Setzer II wrote:
```
```With 3 no blank cells in range
=COUNTBLANK(\$A\$2:\$A\$1000)
Returns 996
These all return 3
=COUNTA(\$A\$2:\$A\$1000)
=COUNTIF(\$A\$2:\$A\$1000,">""")
=COUNTIFS(\$A\$2:\$A\$1000,">""")

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<harvey@nimmo.de>
To:                     libreoffice-users
<users@global.libreoffice.org>
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?

Cheers
Harvey

--
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/
```
```
+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor
(Retired)
```
mailto:mikes@guam.net mailto:msetzerii@gmail.com
```  Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+

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