Counting Duplicate cells in multiple columns - pt2

[dgcuk23]

OK,

I posted a question a couple of days ago and got some great help. But, now that I've looked a bit closer, I think I still need some guidance to get exactly what I need.

I have a sheet with a list of various readers who have opened our last three e-newsletters. I'm trying to identify our highly avid readers (all 3) our avid readers (read 2/3) and our casual readers (read 1/3). I was able to get the proper count for the readers of all 3, but still am having trouble getting those who read only 2.The attached sheet shows what I was trying to do.

The ? really arises in cell b9, which uses the formula previously suggested. However, the correct answer should be 1 instead of 2. Bob read 1&2 only while Fred read 1, 2 & 3.

Any help would be greatly appreciated. We have over 25,000 records in each column and I'd hate to count manually

[DonkeyOte]

Perhaps you want:

B8:
=SUMPRODUCT(--(ISNUMBER(MATCH(A2:A6,B2:B6,0))),--(ISNUMBER(MATCH(A2:A6,C2:C6,0))))

B9:
=SUMPRODUCT(--(ISNUMBER(MATCH(A2:A6,B2:B6,0))),--(ISNA(MATCH(A2:A6,C2:C6,0))))

B10:
=SUMPRODUCT(--(ISNUMBER(MATCH(B2:B6,C2:C6,0))),--(ISNA(MATCH(B2:B6,A2:A6,0))))

B11:
=SUMPRODUCT(--(ISNUMBER(MATCH(A2:A6,C2:C6,0))),--(ISNA(MATCH(A2:A6,B2:B6,0))))

[Everstrivin]

I couldn't get formula's to work under the data but alongside worked well.