Formula for football predictions spreadsheet

Hello all,

I have created a formula that works on football predictions for my office.

If correct score is predicted - 3 points
or
If correct outcome is predicted 1 point

And completly wrong the cell is to be left blank.

I have managed to create this formula ;

=IF(COUNT('Match Results'!$D8,'Match Results'!$E8,Predictions!D8,Predictions!E8)=4,IF(AND('Match Results'!$D8=Predictions!D8,'Match Results'!$E8=Predictions!E8),3,IF('Match Results'!$D8<>'Match Results'!$E8,IF(SIGN('Match Results'!$D8-'Match Results'!$E8)=SIGN(Predictions!D8-Predictions!E8),1)))+0,"")

However the only outcome that will not work is if the match predicted is a 0-0 Draw and people who predicted say 1-1 should get 1 point.

I have attached the spreadsheet if one of you kind people could show me where i am going wrong.

Regards
Grant
Fixture Predictions Grant.xlsm

Great thats worked! now to manually edit 100's of entries

Thanks for your quick response

Is there a way to do this more effectively as changing them one by one will take ages!