Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
basketball schedules templates | Setting up and Configuration of Excel | |||
Basketball Stats | Links and Linking in Excel | |||
ncaa basketball bracket - repost | Excel Discussion (Misc queries) | |||
NCAA Basketball Bracket 2008 | Excel Discussion (Misc queries) | |||
Basketball/Any Sport League Table | New Users to Excel |