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