basketball bracket

[tonyalt3]

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?

 

[Shane Devenshire]

Hi,

I think we are going to need a lot more detail on this? Check to see if
tournament picks are correct? So Excel is going out to a web site and seeing
if the picks are correct?

 

[Luke M]

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)

 

[T. Valko]

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

Another way to write that:

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

 

[Dave Peterson]

Not to be a stick in the mud, but aren't there millions of these online? ESPN,
Yahoo, MSN, even the NYTimes has one.

If you have multiple users, they'd all have to register (I bet), but then you
don't have to worry about checking their entries, validating their picks, ...

 

[Glenn]

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?

http://people.umass.edu/btyler/web/index.htm