Re: [libreoffice-users] Counting cells

2021-03-25 Thread Brian Barker
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

Re: [libreoffice-users] Counting cells

2021-03-25 Thread Andrew Pitonyak
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,

Re: [libreoffice-users] Counting cells

2021-03-25 Thread Michael D. Setzer II
: Joe Conner Subject:[libreoffice-users] Counting cells Date sent: Wed, 24 Mar 2021 21:46:34 -0600 > 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

Re: [libreoffice-users] Counting cells

2021-03-25 Thread Natale Tarantino
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

[libreoffice-users] Counting cells

2021-03-25 Thread Joe Conner
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