Counting occurance of word in list

I’ve had a need to count the number of times a certain value (in this case, a word) appears in a list when using OpenOffice.org.

Here was my problem.  I had a long list of values, each had a status of either “good”, “bad”, or “incomplete”.  I wanted to count the number of times each of the follow occurred.  It turned out to be pretty easy.

Create the following formula where you want the count to be.COUNTIF(range,expression) and bobs your uncle.

Related posts:

1. Share list of files in DropBox Public folder For Windows DropBox users. Here is a simple way to...

Related posts brought to you by Yet Another Related Posts Plugin.