On 2025/04/16 13:43, Brian Barker wrote:
At 11:50 16/04/2025 +0900, Thomas Blasejewicz wrote:
First of all, I have to admit I do not really understand how
functions work.
You don't need to - just how to use them.
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
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?
Possibly because you have actually omitted the leading "=" sign from
your formula in this second cell? Or that you have added a spurious
blank character in front of the "=" sign?
I trust this helps.
Brian Barker
Thank you for your response.
No, the equal signs are there all right and I could not find any blank
spaces either.
There is no difference in the Japanese characters either.
I copied those from one of the cells above and pasted the same thing
into both cells in question.
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
