View Single Post
  #1   Report Post  
MeatLightning
 
Posts: n/a
Default how to count one value or another across multiple columns?

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?