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