Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 24 Aug 2012 02:45:13 +0200Countif on iMachttps://ask.libreoffice.org/en/question/5246/countif-on-imac/I would like to count the number of words in a column that end with a certain letter.
Countif works fine for counting how many start with a certain letter but will not work to count words that end or contain a certain letter.
For example:
COUNTIF(A1:A11,"c.*") works fine but COUNTIF(A1:A11,"*.c") just gives 0.
Any ideas?
ThanksFri, 24 Aug 2012 01:53:56 +0200https://ask.libreoffice.org/en/question/5246/countif-on-imac/Answer by m.a.riosv for <p>I would like to count the number of words in a column that end with a certain letter.
Countif works fine for counting how many start with a certain letter but will not work to count words that end or contain a certain letter.
For example:
COUNTIF(A1:A11,"c.<em>") works fine but COUNTIF(A1:A11,"</em>.c") just gives 0.</p>
<p>Any ideas?</p>
<p>Thanks</p>
https://ask.libreoffice.org/en/question/5246/countif-on-imac/?answer=5247#post-id-5247Try with COUNTIF(A1:A11,".*c")
Search in the help of the program, how to use regular expressions.Fri, 24 Aug 2012 02:45:13 +0200https://ask.libreoffice.org/en/question/5246/countif-on-imac/?answer=5247#post-id-5247