Re: [libreoffice-users] Cannot make formula work

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.lenhardt@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+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

-- 
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