Could you try and copy/paste the formulas into other cells and see what happens. See if the error is replicated. Or if it just disappears which would be fun. I think you will have to ensure the cell numbers are consistent as they may change during the paste. On Wednesday, April 16th, 2025 at 3:42 PM, Thomas Blasejewicz <nyuwa@hb.tp1.jp> 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 BarkerThank 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: 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
-- 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