Formula for using integral values in a chart, blank spaces, and looking for overall concordance.

Hi, I have been working on this for days, and still have not been able to figure this out.  I am definitely not an Excel expert.   I have difficulty with coming up with the Concordance values.   ...