Hi!

What result do you expect based on your example?

6 or 4 ?

Biff

"MeatLightning" wrote in message
...
I have thre columns: One holds names (record keys), another could hold "X",
the last can have a "Y". I want to know how many records have either an
"X"
or a "Y" value?

For example:

Column A Column B Column C
Matt X
Bill Y
John X Y
Fred X Y
Tom

How many records (i.e. column A) have either an X or Y?