Hello,
Please take a look at this spreadsheet. I'm trying to determine win percentages based on price and win/loss streak.MLB.xlsx
So for instance, in cell C61 I'm trying to execute a COUNTIFS array that returns a value based on C3:C55 being anything from 100 to 109, and D3:D55 being a Win, and G3:G55 being 0, and K3:K55 being anything from 100-109, L3:L55 being Win and o3:o55 being 0.
=SUM(COUNTIFS(C3:C55,{100or101or102or103or104or105or106or107or108or109},D3:D55,{"win"},G3:G55,{0}K3:K55,{100or101or102or103or104or105or106or107or108or109},L3:L55,{"win"},O3:O55,{0})
Please help, thank you!