Determine if =, > or < then give count

[bagrantham]

Have 2 respondents (QA and BPA ) scorecards with 25 columns and 16 elements to score example with 7, 4 and 0 as possible scores. How can I get a count that gives me the number of matches, higher and lower than 7? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
CACall 1BPACall1 QACall2
Friendly 7 4 0

Empathy 4 0 7

<o></o>
<o></o>
<o></o>
I have 50 score sheets with 16 different elements only two noted above. Thanks<o></o>
<o></o>

 

[Joe4]

I am not quite certain we are completely clear on your question, but perhaps the COUNTIF formula is what you are looking for (check out the COUNTIF function in Excel's built-in help files).