Hi, Thomas. Would you agree to upload spreadsheet to https://filebin.net and send us the link to take a look? If it contains sensitive data, then you could make a copy and empty contents before uploading.
Greetings Luis Iglesias ----- Mensaje original ----- > De: "Volker Lenhardt" <volker.lenha...@unitybox.de> > Para: "users" <users@global.libreoffice.org> > Enviados: Miércoles, 16 de Abril 2025 14:53:58 > Asunto: Re: [libreoffice-users] Cannot make formula work > Hi Thomas, > > just to make sure: Is cell H2340 formatted as text? > > Volker > > Am 16.04.25 um 04:50 schrieb Thomas Blasejewicz: >> Good morning >> First of all, I have to admit I do not really understand how functions >> work. >> Nevertheless I managed to apply basic items like SUM, AVERAGE or COUNT. >> Recently I found, that COUNTIF can count specific items. >> >> A few times I managed to enter that function and probably got a correct >> answer. >> >> HOWEVER, every here and there only the function, but no value: >> COLUMN H cell 2329 >> =COUNTIF(H2:H2321,"会社員") -> GIVES VALUE = 407 >> >> COLUMN H cell 2340 >> =COUNTIF(H2:H2321,"会社員") -> ONLY SHOWS FORMULA >> >> The Japanese characters here mean "employee" >> >> As far as I can tell, the entered function is in both cells (within the >> same column) are IDENTICAL >> So, why does the function entered in cell 2340 does not return a value? >> What am I missing? >> >> I would very much appreciate a hint, since this is rather frustrating. >> Thank you. >> Thomas >> > > > -- > 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
