Good evening, was hoping for some help on 2 formulas. I am trying to get the total ATS(against the spread) wins and ATS losses in the last 5 games for teams.For example the Texans are 3 ATSW and 2 ATSL.
I have a formula but don't think that it is correct because its giving wrong numbers.
The formula I am using is, =COUNTIF(INDEX(B$2:B$256,LARGE(IF(H$2:I$257=H2,ROW(H$2:I$257)-ROW(B$2)+1),5)):H$257,B2).
The other thing I am looking for is how to calculate current streak, wether its -1 or 1.
As games are played I add the game results to the bottom of the sheet.
Any help again will be so much. appreciated.
Thanks
Bookmarks