Re: [libreoffice-users] Cannot make formula work

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: 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