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 <joeconner2...@gmail.com> 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 many cells contain a number. > >Thank you. > > >-- >To unsubscribe e-mail to: users+unsubscr...@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/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@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/ Privacy Policy: https://www.documentfoundation.org/privacy