Bob, thanks .. albeit I had to drop that into K3 though
before propagating it across/down and up! <g

Just a lingering point though:
England - FR2 will return a zero,
instead of a "blank" (part of the OP's desired result?)

I'm not sure how important the above is to the OP (or to the underlying
beautiful game) to have the result returned as a zero when presumably England
has yet to play the game under MatchID FR2 ??
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bob Phillips" wrote:
Can even simplify it <G

=SUMPRODUCT(--((($A$1:$A$20=$J3)*($B$1:$B$20$C$1:$C$20))+(($D$1 :$D$20=$J3)*
($B$1:$B$20<$C$1:$C$20))),--($E$1:$E$20=K$1),--($B$1:$B$20$C$1:$C$20))+
SUMPRODUCT(--(($A$1:$A$20=$J3)+($D$1:$D$20=$J3)),--($E$1:$E$20=K$1),--($B$1:
$B$20=$C$1:$C$20))/2