Re: [libreoffice-users] Counting cells
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 many cells contain a number. This all depends on what you mean by "a number"! Do you just mean that the cell has something in it, so presumably a number - just anything, i.e. that the cell is not empty? If you mean specifically a number, do you include an explicit zero? And how about a cell that has a blank or blanks, which would be interpreted the same way as zero in many calculation contexts? Note that a cell containing blanks is different from an empty cell; you may or may not wish to include such cells. You probably won't want to include text strings such as "three", even though that is a number in one sense; but how about a cell containing a number expressed as digits but in the form of a text string, e.g. the character "3" as distinct from the numerical value 3? (This may arise from entering a number into a cell formatted as Text or by entering a leading apostrophe - or by pasting material from elsewhere.) The COUNT() function ignores empty cells and those that contain text, so may well be all you need. Otherwise you may like to consider formulae involving COUNTA() or COUNTIF(). Note also that it is sometimes easier to calculate the inverse of something, so you could consider using COUNTBLANK() (which should really be called COUNTEMPTY(), since it fails to include cells containing explicit blank spaces), and subtracting the result from the number of cells in the range. Exactly what you choose to do depends on how resilient you want your spreadsheet to be to rogue or erroneous cell contents as a result of later errors on your part (we all make them) or on the part of others who may use the spreadsheet. I trust this helps. Brian Barker -- 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
[libreoffice-users] Search for extension updates not working?
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 updates to three extensions in all. I did a quick bug report check and saw nothing about the extension manager. Are others seeing this? A known issue? Thanks, Roy -- 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
Re: [libreoffice-users] Counting cells
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, 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
Re: [libreoffice-users] difficulty with base
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 écrit : Hi Moebius, here the simple solution: Put away the table "codes". Edit table "Personnens" → add the field "Villes_ID" to "Personnes" (should be INTEGER; foreignkey from table "Villes") → delete the fields "Codepost" and "Ville" from this table. You will get this information from "Villes". You will search for "Villes" or "PostCode" later? Create a table filter for only one row. Fields are like the fields in "Villes". The field "ID" could be boolean. Together with thgis table you could search for every "PostCode" or "Ville". Here a complicated solution: Rows of table "codes" will appear many times in "Villes". Rows of table "Villes" will also appear many times in "codes". You have to delete the "postalcode" für "Villes". You have to create a combination of the two elements together in table "Personnes". Change the fields "Codepost" and "Ville" from this table to INTEGER fileds. They will contain the foreignkey from the tables "Villes" and "code". I would prefer the simple method. You have to edit only one table to cretae the mostly used combinations of "Code" and "Ville". Then you could choose the values from this table in a listbox to put the foreignkey to "Personnes". Lets see whot you need for per private mail. Thins ist is too special for other people in this mailinglist. Regards Robert -- 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
Re: [libreoffice-users] Counting cells
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 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
Re: [libreoffice-users] Counting cells
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 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
[libreoffice-users] Counting cells
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
