I am trying to count the matches of two rows of cell data and put the total in cell S8.



It works on a cell to cell match.
=COUNTIF(B5,B8)

I cannot figure out how to check TWO rows and add the total of
matches in cell S8.

I am looking to match
B5, C5, D5, E5, F5, G5, H5, I5, J5, K5, L5, M5, N5, O5, P5, Q5
against
B8, C8, D8, E8, F8. G8. H8. I8. J8. K8, L8, M8, N8. O8. P8, Q8

Any help will be appreciated.

This is for my "entertainment purpose only" football pool

Attached Files

example.xls (78.5 KB, 12 views)