Wins in the Last 5

[xpost][/xpost]

crossposted: https://www.excelforum.com/exc…-5-games.html#post5527795

Good morning, the last post the help was amazing, thank you very much for that!! Was hoping with help for 2 more things, I want to find the following,

-ATS(against the spread) wins and ATS losses in the last 5 games.

-ATS Streak

I have a formula inputed in the workbook for the Texans but i'm not sure if that is correct. As games are played I add the data to the bottom of the columns.

Any help again will be so much. appreciated.

Thanks

Hello, this has been resolved. A formula was found from another site. Sorry about the confusion.

Good morning thanks for bringing this up. I have attached the workbook with the resolution. The formula is as follows,

For wins,

=SUMPRODUCT(($B$2:$C$500=$L2)*($H$2:$I$500="W")*(ROW($B$2:$C$500)>=AGGREGATE(14,6,ROW($B$2:$C$500)/($B$2:$C$500=$L2),5)))

For losses,

=SUMPRODUCT(($B$2:$C$500=$L2)*($H$2:$I$500="L")*(ROW($B$2:$C$500)>=AGGREGATE(14,6,ROW($B$2:$C$500)/($B$2:$C$500=$L2),5)))