Howdy,

If I have the following:

Fred none Amy early
John late Dave late
Kim early Sam early
Brad none Lisa late

I want to know how many rows where both people are listed as either "none" OR "late"

So in this example my answer should be 2 as John & Dave both have late and Brad & Lisa have none & late.

Thanks in advance for any help!