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 points

correct winning team prediciton-3

one sides score right- 1 pointi want the score of the person to appear on the top of the spreadsheet.

Thanks

Dan

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.

if i email you my spreadsheet would you be able to make more sense of it?

I don't know. I've sent you an email addy via PM. Please do not share it with anyone.

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History