soccer data - COUNTIF question

[CR1989]

[TABLE="width: 152"]
<colgroup><col style="width: 21pt; mso-width-source: userset; mso-width-alt: 1024;" width="28"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1718;" width="47"> <col style="width: 48pt;" span="2" width="64"> <tbody>[TR]
[TD="width: 28, bgcolor: transparent"]Arsenal[/TD]
[TD="width: 47, bgcolor: transparent"]Aston Villa[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]1[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Liverpool[/TD]
[TD="bgcolor: transparent"]Stoke[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Norwich[/TD]
[TD="bgcolor: transparent"]Everton[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Sunderland[/TD]
[TD="bgcolor: transparent"]Fulham[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Swansea[/TD]
[TD="bgcolor: transparent"]Man United[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]West Brom[/TD]
[TD="bgcolor: transparent"]Southampton[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]West Ham[/TD]
[TD="bgcolor: transparent"]Cardiff[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Chelsea[/TD]
[TD="bgcolor: transparent"]Hull[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Crystal Palace[/TD]
[TD="bgcolor: transparent"]Tottenham[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Man City[/TD]
[TD="bgcolor: transparent"]Newcastle[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

I Have the above data set. i want to be able to count the number of times a certain club, say LIverpool, has been involved in a match with >1 goal in it. basically count the number of times a given value in the 1st 2 columns has a sum of >1 in the two adjacent columns. I've tried vlookup but i wanna look for a given value across more than one column. i've also tried countif but no luck. anyone can help wth this?

 

[Asala42]

A Sumproduct will do it. This tested well:

=SUMPRODUCT(--(($A$2:$A$100="Man City")+($B$2:$B$100="Man City")),--(($C$2:$C$10+$D$2:$D$100)>1))

 

[CR1989]

woked perfectly, thanks a million!

 

[kirk9992]

DSUM would work too.