counting words

[scot]

I'm trying to count how many times the word, "false" appears in a coloumn
range of: F1:F2500

I've formated the "F" coloumn to analize and put either a, false or true, if
the coloumns, "A1:2500 and B1:2500" do or don't match.

Now I'd like to count, sort, find all the falses. Too many with a list of
2500. I've thought there was a way to also deliniate and show which row/cell
each of the falses are in.

This would help me tremendously as once I count them I'll know how many and
where I need to update.

I'm sure theres a simple answer but I've not found it. Can anyone help me
out?


scot

 

[T. Valko]

If they're Boolean FALSE try this:

=COUNTIF(F:F,FALSE)

If they're text string false try this:

=COUNTIF(F:F,"FALSE*")

 

[Jacob Skaria]

Try
=COUNTIF(F1:F2500,FALSE)