Viking Supporters Co-operative

Viking Chat => Off Topic => Topic started by: GazLaz on January 10, 2020, 08:25:50 am

Title: Any MS Excel wizards on here?
Post by: GazLaz on January 10, 2020, 08:25:50 am

I am wanting to draw information from a list of football results. The games are listed under the headings DATE HOME GOALS AWAY GOALS. I know the formula to sum total goals of a selected team under certain criteria BUT I don’t know how to set the criteria as the last X amount of games using the date as a reference.

Anyone any idea how to do this?

Title: Re: Any MS Excel wizards on here?
Post by: Ldr on January 10, 2020, 08:51:13 am

You need to use an Offset formula. Google offset and mr excel

Title: Re: Any MS Excel wizards on here?
Post by: GazLaz on January 10, 2020, 09:32:33 am

Quote from: Ldr on January 10, 2020, 08:51:13 am

You need to use an Offset formula. Google offset and mr excel

Thanks for the advice!