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 <ny...@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 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: users+unsubscr...@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+unsubscr...@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
