Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 14 Jun 2017 09:57:41 +0200Count frequency of text in spreadsheethttps://ask.libreoffice.org/en/question/85128/count-frequency-of-text-in-spreadsheet/How do you count the frequency of a word appearing in a spreadheet?
E.G.
My spreadsheet lists several institutions and the last time or next time they were or should be "Checked"
There are 4 columns with months (January-December) listed for reference on when each item should be checked.
How do I search the spreadsheet and get a sum of how many times "January" for example shows up in the sheet?
I have tried the SumIF and CountIF functions and I keep getting error messages in response in both in Excell and Open Office Calc.
I have also tried the "Find All" function which highlights everything but wont quantify...
This is such a simple function I was hoping for a simple way to get to it but have been having so much trouble.
(I am also a spreadsheet newbie- simple walkthroughs appreciated)Thu, 05 Jan 2017 19:47:03 +0100https://ask.libreoffice.org/en/question/85128/count-frequency-of-text-in-spreadsheet/Comment by m.a.riosv for <p>How do you count the frequency of a word appearing in a spreadheet?</p>
<p>E.G.
My spreadsheet lists several institutions and the last time or next time they were or should be "Checked"</p>
<p>There are 4 columns with months (January-December) listed for reference on when each item should be checked. </p>
<p>How do I search the spreadsheet and get a sum of how many times "January" for example shows up in the sheet?</p>
<p>I have tried the SumIF and CountIF functions and I keep getting error messages in response in both in Excell and Open Office Calc. </p>
<p>I have also tried the "Find All" function which highlights everything but wont quantify... </p>
<p>This is such a simple function I was hoping for a simple way to get to it but have been having so much trouble. </p>
<p>(I am also a spreadsheet newbie- simple walkthroughs appreciated)</p>
https://ask.libreoffice.org/en/question/85128/count-frequency-of-text-in-spreadsheet/?comment=85135#post-id-85135Can you share a file with a sample data on where you want to do the calculation?Thu, 05 Jan 2017 22:45:59 +0100https://ask.libreoffice.org/en/question/85128/count-frequency-of-text-in-spreadsheet/?comment=85135#post-id-85135Answer by librebel for <p>How do you count the frequency of a word appearing in a spreadheet?</p>
<p>E.G.
My spreadsheet lists several institutions and the last time or next time they were or should be "Checked"</p>
<p>There are 4 columns with months (January-December) listed for reference on when each item should be checked. </p>
<p>How do I search the spreadsheet and get a sum of how many times "January" for example shows up in the sheet?</p>
<p>I have tried the SumIF and CountIF functions and I keep getting error messages in response in both in Excell and Open Office Calc. </p>
<p>I have also tried the "Find All" function which highlights everything but wont quantify... </p>
<p>This is such a simple function I was hoping for a simple way to get to it but have been having so much trouble. </p>
<p>(I am also a spreadsheet newbie- simple walkthroughs appreciated)</p>
https://ask.libreoffice.org/en/question/85128/count-frequency-of-text-in-spreadsheet/?answer=99830#post-id-99830To get a sum of how many times "January" shows up in the sheet, you could type a formula such as:
=COUNTIF(A1:Z9999;"January")
The first parameter of the COUNTIF() function specifies the range of cells to be searched. In this example it is assumed that your sheet does not contain any column beyond Z, nor any row beyond 9999.Wed, 14 Jun 2017 09:57:41 +0200https://ask.libreoffice.org/en/question/85128/count-frequency-of-text-in-spreadsheet/?answer=99830#post-id-99830