Hi I'm currently making a world cup score predictor in excel and have the formulae below which works perfectly but struggling to keep track of result as it counts blank cells as a draw, wondering if any one would know how to incorporate the COUNTA feature or if there is another way around it so it ignores blank cells?
=IF(OR((I8>J8)-(M8>N8),(I8<J8)-(M8<N8)),0,IF(AND(I8=M8,J8=N8),3,2))
Bookmarks