[libreoffice-users] Cannot make formula work

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