# Excel World cup predictor

Microsoft Office excel 2007 home & stude...
June 14, 2010 at 13:16:10
Specs: Windows 7
 I am trying to create a world cup predictor for the knock out stages of the competition. I need help automating the scoring. The scoring is as follows:correct prediction - 7 points correct winning team prediction with 1 sides score correct- 4 pointscorrect winning team prediciton-3one sides score right- 1 pointi want the score of the person to appear on the top of the spreadsheet.ThanksDan

See More: Excel World cup predictor

#1
June 14, 2010 at 13:53:59
 Since none of us can see your spreadsheet from where we're sitting, it's kind of hard to know what you are looking for, other than "i want the score of the person to appear on the top of the spreadsheet"As an example for Person 1, you could...1 - Merge cells A1:D1 and put in their name.2 - Merge cells A2:D2 and put in this formula:=SUM(COUNTIF(A5:A7,"=X")*7,COUNTIF(B5:B7,"=X")*4,COUNTIF(C5:C7,"=X")*3,COUNTIF(D5:D7,"=X")*1)3 - In Row 3, Columns A - D, put a label for each of your "criteria".5 - In Rows 5 - 7, put an X under the criteria that fits the "prediction" that person made and the score will appear in the merged cell.As you add X's in any of that person's columns, the formula will COUNT them and then SUM the "count times the multiplier" for each of the 4 columns.In other words, 2 X's in Column A and 1 in Column C will total 17 points.A5:A7, B5:B7, etc. will get you through 3 games. I don't know anything about World Cup brackets, so feel free to adjust this as required.Replicate this method in E:H for Person 2, I:L for Person 3, etc.BTW...this made sense when I read it, but that's because I wrote it. ;-)Let me know if I've totally confused you.

Report •

#2
June 14, 2010 at 14:32:44
 if i email you my spreadsheet would you be able to make more sense of it?

Report •

#3
June 14, 2010 at 16:17:35
 I don't know. I've sent you an email addy via PM. Please do not share it with anyone.

Report •
Related Solutions