How do you count "W" values and "L" values for the last 10 entries in an unlimited range? And stop counting if a certain value number is reached? The range is unlimited because every week (and sometimes months) a new entry may or may not be entered.
Thus far I have in Current Wins formula: =COUNTIF(F4:P4,"W")
In the Current Losses formula I have: =COUNTIF(F4:P4,"L")
Thus far I have in Current Wins formula: =COUNTIF(F4:P4,"W")
In the Current Losses formula I have: =COUNTIF(F4:P4,"L")