+ Reply to Thread
Results 1 to 13 of 13

Sum the goals of last 5 matches of a team in a cell

  1. 05-03-2023, 05:24 PM #1
    Billagrinio
    Billagrinio is offline
    Registered User
    Join Date
    03-20-2022
    Location
    Greece
    MS-Off Ver
    Office 2019 Pro
    Posts
    16

    Sum the goals of last 5 matches of a team in a cell

    Hello everyone!

    I have 5 cells: Dates (from new to old), Home Team, Away Team, Home scored, Away Scored.
    I have all fixtures of a league at 2023 until now, except fixtures that not played yet.

    What i need is to sum the goals in last 5 matches Home team scored before the match that plays next. So if league started September and now is May i need to sum how many goals home team scored in the last 5 matches before the Match plays now at May.


    Is that possible? I tried match and index but my skills is not so good.
    Thanks for anyone who tries!!!
    Reply With QuoteRegister To Reply
  2. 05-03-2023, 06:47 PM #2
    bsalv
    bsalv is offline
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Sum the goals of last 5 matches of a team in a cell

    with an aggregate formula that's possible. Do you have an example ?
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
    Reply With QuoteRegister To Reply
  3. 05-04-2023, 01:21 PM #3
    Billagrinio
    Billagrinio is offline
    Registered User
    Join Date
    03-20-2022
    Location
    Greece
    MS-Off Ver
    Office 2019 Pro
    Posts
    16

    Re: Sum the goals of last 5 matches of a team in a cell

    For example if i have league results of a league, i want before a match to sum the each team scored in their last 5 matches home and away! and if is ease a new section tha sums last five goals scored at home and new cell for last five goals scored for away team.

    At example for last 5 scored home and away are at O and P columns. As you see at last match i put manualy last 5 scored for each.
    Is this possible for last 5 home and away and for only home for home and away for away team at Q and R
    Attached Files Attached Files
    Last edited by Billagrinio; 05-04-2023 at 01:24 PM. Reason: attach file
    Reply With QuoteRegister To Reply
  4. 05-04-2023, 02:10 PM #4
    bsalv
    bsalv is offline
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Sum the goals of last 5 matches of a team in a cell

    for the moment only last 5 home or away, not home or away (i know the rows, but can't find a correct formula for the moment.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 05-05-2023, 05:16 PM #5
    Billagrinio
    Billagrinio is offline
    Registered User
    Join Date
    03-20-2022
    Location
    Greece
    MS-Off Ver
    Office 2019 Pro
    Posts
    16

    Re: Sum the goals of last 5 matches of a team in a cell

    How could i have it in O and P for every match ? In O only sum the goals scored by home team in last 5 matches and in P the same for away! If not 5 matches played to show error or value
    Reply With QuoteRegister To Reply
  6. 05-05-2023, 05:31 PM #6
    bsalv
    bsalv is offline
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Sum the goals of last 5 matches of a team in a cell

    you have 2019, if you had 365 it's easier !!! What is your version ?
    Attached Files Attached Files
    Last edited by bsalv; 05-05-2023 at 05:51 PM.
    Reply With QuoteRegister To Reply
  7. 05-05-2023, 05:32 PM #7
    Billagrinio
    Billagrinio is offline
    Registered User
    Join Date
    03-20-2022
    Location
    Greece
    MS-Off Ver
    Office 2019 Pro
    Posts
    16

    Re: Sum the goals of last 5 matches of a team in a cell

    No only pro plus 2019
    Reply With QuoteRegister To Reply
  8. 05-05-2023, 05:52 PM #8
    bsalv
    bsalv is offline
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Sum the goals of last 5 matches of a team in a cell 

    Please Login or Register  to view this content.
    see file in #6
    Reply With QuoteRegister To Reply
  9. 05-05-2023, 06:26 PM #9
    Billagrinio
    Billagrinio is offline
    Registered User
    Join Date
    03-20-2022
    Location
    Greece
    MS-Off Ver
    Office 2019 Pro
    Posts
    16

    Re: Sum the goals of last 5 matches of a team in a cell

    Nice this is for both home and away sum! If i want only for home for home team and only away for away team ?
    Reply With QuoteRegister To Reply
  10. 05-05-2023, 06:39 PM #10
    bsalv
    bsalv is offline
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Sum the goals of last 5 matches of a team in a cell

    the last 5 home matches for the home-team and the last 5 away matches for the away-team ?
    Reply With QuoteRegister To Reply
  11. 05-05-2023, 06:42 PM #11
    Billagrinio
    Billagrinio is offline
    Registered User
    Join Date
    03-20-2022
    Location
    Greece
    MS-Off Ver
    Office 2019 Pro
    Posts
    16

    Re: Sum the goals of last 5 matches of a team in a cell

    YeaP only Home last 5 for home and only Away last 5 for away (sum for each)
    Reply With QuoteRegister To Reply
  12. 05-05-2023, 06:54 PM #12
    bsalv
    bsalv is offline
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Sum the goals of last 5 matches of a team in a cell

    columns R & S
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  13. 05-07-2023, 11:47 AM #13
    Billagrinio
    Billagrinio is offline
    Registered User
    Join Date
    03-20-2022
    Location
    Greece
    MS-Off Ver
    Office 2019 Pro
    Posts
    16

    Re: Sum the goals of last 5 matches of a team in a cell

    U are amazing!!! Thanks a lot for your time and your help!!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Running count of football team's last ten games with x goals
    By fetaklaci in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-15-2021, 08:43 AM
  2. [SOLVED] find number of soccer matches with more than 1,5 goals scored
    By Tresfjording in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-02-2019, 11:03 AM
  3. [SOLVED] Team's scored goals
    By juskaa in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-12-2017, 09:31 AM
  4. Golf team to individual matches
    By hobbsofmi in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-08-2014, 12:31 PM
  5. [SOLVED] How can i find team name from above and count the averige of goals
    By Ipinho100 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-19-2013, 08:23 AM
  6. [SOLVED] Counting Information (e.g. Goals, Corners) from a Series of Matches
    By mrvp in forum Excel General
    Replies: 4
    Last Post: 05-26-2012, 12:50 PM
  7. league team matches
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2010, 07:12 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1