basketball bracket
 

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?

basketball bracket
 

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?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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?

basketball bracket
 

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?

basketball bracket
 

=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?

basketball bracket
 

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, ...



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?

--

Dave Peterson

basketball bracket
 

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?


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