Conditional Running Average Separate Column

So I'm trying to get this worksheet together for my friend and it contains data for his favorite NHL team the Det. Red Wings. He wanted to know the running win percentages of their 2007 season. I am a programmer however, never worked with excel very much.

I was able to parse out the data he gave me but I ran into problems when I hit the away/home/total win percentages.

The running away win percentage should be calculated by the number of current away wins / number of away games played. Do I need to make more columns to contains Road Wins and Home Wins. It seems that I should be able to have a formula do this and then apply it to each cell.

Thats exactley what I needed thank you!

What about maybe a running average of the past 15 games. How would one do that?

Originally Posted by sglife

I think this is what you need

Please Login or Register  to view this content.