Predictor Formula

Hello all,

I'm seeking some help I'm what you call an Excel idiot!

I'm running a Euro 2016 Predictor and I've got the rules below set in place:

10 Point's awarded for predicting the correct result and the correct score for both teams.

7 Points awarded for predicting the correct result and the correct score for only 1 of the teams.

5 Points awarded for a correct result, but the wrong score for both teams.

2 Points awarded for the wrong result, but the correct score for 1 of the teams.

So the formula I'm using is this:

=IF(COUNT('Fixtures & Results'!$G6:'Fixtures & Results'!$H6,'Sheet4'!G6:H6)=4,(2*OR('Fixtures & Results'!$G6='Sheet4'!G6,'Fixtures & Results'!$G6='Sheet4'!H6))+(5*(SIGN('Fixtures & Results'!$G6-'Fixtures & Results'!$H6)=SIGN('Sheet4'!G6-'Sheet4'!H6)))+(3*AND('Fixtures & Results'!$G6='Sheet4'!G6,'Fixtures & Results'!$H6='Sheet4'!H6)),"")

Which I copied from another sheet we run when the season is on. I just amended it for my needs.

Basically my question is, is there anything obvious to show why this doesn't work correctly.

I get the 10 points for the correct score so I know that bit is working but the rest doesn't.

Can anyone please be a massive help.

I really appreciate it.

Many Thanks

Michael

Try

=IF(COUNT('Fixtures & Results'!$G6:$H6,Sheet4!$G6:$H6)=4,IF(AND(SIGN('Fixtures & Results'!$G6-'Fixtures & Results'!$H6)=SIGN(Sheet4!$G6-Sheet4!$H6)),IF(AND('Fixtures & Results'!$G6=Sheet4!$G6,'Fixtures & Results'!$H6=Sheet4!$H6),10,IF(OR('Fixtures & Results'!$G6=Sheet4!$G6,'Fixtures & Results'!$H6=Sheet4!$H6),7,5)),IF(OR('Fixtures & Results'!$G6=Sheet4!$G6,'Fixtures & Results'!$G6=Sheet4!$H6),2,"")))