At 21:46 24/03/2021 -0600, Joe Conner wrote:
I am confused about how to count a number of cells that have a
number. In Calc, if cells a1:a11 each may or may not have a number
in it, what formula may I use to count how many cells have a number?
I do not want the sum of the numbers, just how
I had a problem with LO Writer 7.1.2.1 (Mageia Linux) crashing when
opening a document and discovered that it was a problem with a not-up-
to-date Language Tool extension. The problem is that I had checked with
the Extension Manager and it reported no updates. Looking one by one I
have discovered
Not near a computer to test but I think you want the countif function
Get BlueMail for Android
On Mar 25, 2021, 5:13 AM, at 5:13 AM, Joe Conner
wrote:
>I am confused about how to count a number of cells that have a number.
>In Calc, if cells a1:a11 each may or may not have a number in it,
Bonjour,
Thank you for your answer.
I'm gonna try this even if some details keeps a little obscure.
Perhaps, if you get time, could you modify the example base in the way
you suggest ; I'll take a big look to it to see how you've done ?
cordialement,
Le 23/03/2021 à 20:35, Robert Großkopf a
Just did a quick test. Put 1 to 5 in A1 to A5, A to D in A6
to A9, left A10 and A11 blank.
=count(a1:a11) gives 5
=counta(a1:a11) gives 9
Countif could do other variations.
On 24 Mar 2021 at 21:46, Joe Conner wrote:
To: users@global.libreoffice.org
From:
Hi,
the countif function may be just for you
N.
Il 25/03/2021 04:46, Joe Conner ha scritto:
I am confused about how to count a number of cells that have a number.
In Calc, if cells a1:a11 each may or may not have a number in it, what
formula may I use to count how many cells have a number? I do
I am confused about how to count a number of cells that have a number.
In Calc, if cells a1:a11 each may or may not have a number in it, what
formula may I use to count how many cells have a number? I do not want
the sum of the numbers, just how many cells contain a number.
Thank you.
--
To