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

If they're Boolean FALSE try this:

=COUNTIF(F:F,FALSE)

If they're text string false try this:

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

--
Biff
Microsoft Excel MVP


"scot" wrote in message
...

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

Try
=COUNTIF(F1:F2500,FALSE)

--
Jacob


"scot" wrote:


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