compare two cells with OR function

**ghladik** · 12-10-2012, 04:21 PM

I have a speadsheet of 3,000 rows. I attached a sample.

I am trying to count the number of rows that have any combination of the following

Some High School for both columns
High School Graduate for Both Columns
a combination of the two above.

compare two cells.xlsx

**Ace_XL** · 12-10-2012, 04:28 PM

In A2 use

=--(COUNTIF(A2:B2,"*High school*")>0)

Copy down

**ghladik** · 12-10-2012, 04:36 PM

Can you talk me through what the formula means? Why the two -- before and why the >0 after?

**Ace_XL** · 12-10-2012, 04:49 PM

Originally Posted by ghladik

Can you talk me through what the formula means? Why the two -- before and why the >0 after?

The >0 returns TRUE in case of any matches with high school and wild characters *. The -- converts TRUE to 1 and FALSE to 0

**FDibbins** · 12-10-2012, 04:47 PM

this gives a total of 6...

=COUNTIFS(A2:A27,"*High school*",B2:B27,"*High school*")

edit: Ace, fromthe looks of it, your formula gives a 1 for if "either" parent have *High school*. I think the OP wanted "both Father and Mother have eitehr a "High School Degree" or "Some High School"