Make your formula:

=IF(AND(A11="",B11=""),"",IF(OR(COUNT(A11:B11)=1,A 11=B11),1,""))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"pm" wrote in message
...
Hello,

I have a list of 12,000 rows separated into two columns. In each row, the
two columns either match or don't. So I've made a third column that is
just
a simple "if" function in each row that puts a "1" in if the two columns
differ. I then use a "countif" at the bottom to tally the # of different
rows.

The problem I am running into is that some of the rows have one column
with
an empty cell (no data). So for this row I would have data for one
column,
but not both. Obviously according to my functions, excel will count these
as
different. I would like these rows to not be counted as different. Does
anyone know how to exclude rows where one of the columns has no data from
being counted as "different"?

As always, many thanks in advance.