"Dave Peterson" wrote in message
...
Ohhhhhh.

How many times did Wigan beat anyone both home and away....


3 times


I guess I'd do each individually and instead of adding the home and way
totals,
I'd multiply them:

=(SUMPRODUCT(--(d2:d100="wigan"),
--(f2:f100="Sunderland"),
--(e2:e100g2:g100))0)
*(SUMPRODUCT(--(f2:f100="wigan"),
--(df2:d100="Sunderland"),
--(e2:e100<g2:g100))0)

Do this for each pair of teams and then add them up.


Lot of formulae <G!


Do you have a fancier formula that works?

Not fancy, I posted this just before you joined ...


put the name of the target team in H2, then in H3 add the formula

=IF(AND(D3=H$2,E3G3,MAX(IF(($D$3:$D$40=F3)*($F$3: $F$40=D3)*($E$3:$E$40<$G$3
:$G$40),1))),F2,"")

which is an array formula, so commit it with Ctrl-Shift-Enter, not just
Enter.

Copy H3 down to H40.

This will list the name of the beaten team in column H in the row where they
are the away team.

This lists all the teams that the double is done over, so a simple COUNTA
gets the count.