Hi,
I'm trying to figure out a formula to record the win and loss streaks for both teams to score in a football match.
I have attached a copy of my issue...
Hi,
I'm trying to figure out a formula to record the win and loss streaks for both teams to score in a football match.
I have attached a copy of my issue...
I am not sure what you want and if your sample file contains enough data, or the expected result. Win and loss streaks to score is strange english
you can calculate both teams winning streaks? and to win you would have to score?
Please explain a bit more
in H2 =IF(E2*F2>0,SUM(H1,1),0)
in i2 =IF(E2*F2=0,SUM(i1,1),0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks