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 <joeconner2007@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+unsubscribe@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:mikes@guam.net mailto:msetzerii@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- To unsubscribe e-mail to: users+unsubscribe@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