=SUM(IF((B2:B64=A2:A64)*NOT(ISBLANK(A2:A64)),1,0) )

Another way to write that:

=SUMPRODUCT(--(A2:A64<""),--(A2:A64=B2:B64))


--
Biff
Microsoft Excel MVP


"Luke M" wrote in message
...
I'm assuming this is for the NCAA, in which there are 63 games.

Input this formula as an array! (Use Ctrl+Shift+Enter to confirm).
=SUM(IF((B2:B64=A2:A64)*NOT(ISBLANK(A2:A64)),1,0))

Enter person's choices in range A2:A64, game outcomes in B2:B64. (or
something similar). Either way, you want to write your formula so that it
compares an array of choices with array of truths (game outcomes) and sums
the matches (remember, true = 1, false=0)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"tonyalt3" wrote:

Does anyone out there have a spreadsheet that would check to see if
tournament picks are correct/incorrect and then total up points on a
summary page?