Ask Your Question

Count frequency of text in spreadsheet

asked 2017-01-05 19:47:03 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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)

edit retag flag offensive close merge delete


Can you share a file with a sample data on where you want to do the calculation?

m.a.riosv gravatar imagem.a.riosv ( 2017-01-05 22:45:59 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-06-14 09:57:41 +0200

librebel gravatar image

To get a sum of how many times "January" shows up in the sheet, you could type a formula such as:


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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-05 19:47:03 +0200

Seen: 409 times

Last updated: Jun 14 '17