If cells are blank, ignore them. Multiple formulas!

I see that you fixed the problem from your initial thread, based on my suggestion, but gave no reply that it fixed your problem...
http://www.excelforum.com/showthread...15#post4374115

While we cannot make members at least have the courtesy to respond to suggestions made, those members that make a habit of this behavior, tend to not get many responses to future requests.

Also, your attached file does not match your picture - which I advised you against posting in your other thread

And this is why we request sample files

You have a trailing space after the 2nd Villarreal - remove that and you should be good
Probably would not have seen that in a screen shot

So, with that said, explain what you want, please

surely if they are both empty (neither side scored), that is a draw too?

What answer are you expecting?
this gives 0
=SUMPRODUCT(($M$2:$M$11="Real Madrid")*($N$2:N$11>$O$2:$O$11)+(($P$2:$P$11="Real Madrid")*($O$2:$O$11=$N$2:N$11)*AND(N2:N11<>0,O2:O11<>0)))