Formular Help

[U.F.O]

The following formualr finds the number of matched bets for a selection.

=SUMPRODUCT((MyBets!B1:B1000=A5)*(MyBets!E1:E1000="F"))

If i wanted to find the number of matched BACK bets only for example how would i do that ?, carn't get my head round it

thanks

[osknows]

=SUMPRODUCT((MyBets!B1:B1000=A5)*(MyBets!E1:E1000="F")*(MyBets!F1:F1000="B"))

or if you have Excel 2007+

=COUNTIFS(MyBets!B1:B1000,A5,MyBets!E1:E1000,"=F",MyBets!F1:F1000,"=B")

[U.F.O]

Great, Thanks

[U.F.O]

Any idea how i could get the sum of the stakes of the Matched back Bets
as well ?

[osknows]

yes

=SUMPRODUCT(MyBets!C1:C1000,(MyBets!B1:B1000=A5)*(MyBets!E1:E1000="F")*(MyBets!F1:F1000="B"))

or

=SUMIFS(MyBets!C1:C1000,MyBets!B1:B1000,A5,MyBets!E1:E1000,"=F",MyBets!F1:F1000,"=B")