Hi Brian. In your quoted text the first countif has periods and the
second one has commas. Did you do that or does it hint at some character
(uni)code differences even though they look the same.
On 16/04/25 5:42 pm, Thomas Blasejewicz wrote:
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
