+ Reply to Thread
Results 1 to 4 of 4

formula to measure both teams to score win and loss streaks

  1. #1
    Registered User
    Join Date
    08-29-2018
    Location
    England
    MS-Off Ver
    2007
    Posts
    10

    formula to measure both teams to score win and loss streaks

    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...
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: formula to measure both teams to score win and loss streaks

    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

  3. #3
    Registered User
    Join Date
    08-29-2018
    Location
    England
    MS-Off Ver
    2007
    Posts
    10
    Quote Originally Posted by davsth View Post
    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
    I want to measure whether or not the home AND away team, have scored at least one goal and record it as a win, but if only one or neither team score it is recorded as a loss. it is a popular bet amongst punters

  4. #4
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: formula to measure both teams to score win and loss streaks

    in H2 =IF(E2*F2>0,SUM(H1,1),0)
    in i2 =IF(E2*F2=0,SUM(i1,1),0)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula to measure whether or not both teams have scored for football data
    By Jim.water in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-29-2018, 04:39 PM
  2. [SOLVED] Calculate win/loss streaks
    By Jim.water in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-29-2018, 09:04 AM
  3. Help. Calculate win/loss streaks
    By ziggy1971 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2017, 01:37 AM
  4. Replies: 9
    Last Post: 01-20-2016, 08:59 AM
  5. Exclude zero when counting streaks (win/loss) and current streaks
    By poko10 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-11-2013, 06:06 AM
  6. [SOLVED] WIN/LOSS streaks
    By rumihasj in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2013, 11:39 AM
  7. Replies: 6
    Last Post: 06-04-2013, 03:16 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1