Conditional Running Average Separate Column

**sglife** · 10-14-2008, 08:36 PM

I think this is what you need

I2=IF(H2=0,0,SUMPRODUCT(($D$2:$D2="W")*($C$2:$C2<>"Joe Louis Arena"))/H2)
J2=IF(G2=0,0,SUMPRODUCT(($D$2:$D2="W")*($C$2:$C2="Joe Louis Arena"))/G2)
K2=COUNTIF($D$2:$D2,"w")/COUNTA($D$2:$D2)

**Halo** · 10-14-2008, 09:30 PM

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

I2=IF(H2=0,0,SUMPRODUCT(($D$2:$D2="W")*($C$2:$C2<>"Joe Louis Arena"))/H2)
J2=IF(G2=0,0,SUMPRODUCT(($D$2:$D2="W")*($C$2:$C2="Joe Louis Arena"))/G2)
K2=COUNTIF($D$2:$D2,"w")/COUNTA($D$2:$D2)