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: [email protected]
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
