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
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$1, ISBLANK=0) is getting
0 from range, but the counts the isblank=0 as an item?
On 25 Jun 2022 at
On 25/06/2022 21:28, Ian Bertram wrote:
>
> I have a long document (156 pages) plus a cover page. I want the cover page
> to be unnumbered and the numbering to start with the second page of the
> document. I’ve tried using page styles and got the second page to show as 1,
> but the header
I have a long document (156 pages) plus a cover page. I want the cover page to
be unnumbered and the numbering to start with the second page of the document.
I’ve tried using page styles and got the second page to show as 1, but the
header also appeared on the cover page and also as Page 1.
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$1, 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,
On 25/06/2022 03:21, Chris J. wrote:
Hi.
Running Ubuntu 22.04 with LO 7.3.4.2 Ubuntu package 1:7.3.4. Before you ask,
yes I RTFMed. Still can't get this working.
I write stories where the chapters are individual files. First chapter has
pages 1-15. Second chapter in a whole other file has