We will be migrating from Ask to Discourse on the first week of August, read the details here

 Ask Your Question

# Count frequency of text in spreadsheet [closed]

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

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 reopen merge delete

## Comments

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

( 2017-01-05 22:45:59 +0200 )edit

## 1 Answer

Sort by » oldest newest most voted

To 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.

more

## Stats

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

Seen: 3,752 times

Last updated: Jun 14 '17