Excel Help (Equations)

[MexicanStallion]

How can I update AVG and OBP each week?

AB (C), Hits (E), SF (M)

I don't know how to make the right equation other than doing it the super long way by doing E3+E4+E5/C3+C4+C5 etc..

[MonkeyF0cker]

=sum(e3:e999999)/sum(c3:c999999)

[BIGDAY]

Fuk this Sh!t Stallion!!!

Pound some MMA.

[MexicanStallion]

=sum(e3:e999999)/sum(c3:c999999)

Thanks. Makes sense. I was forgetting to add the second SUM.

And for OBP? H(E)+BB(J)/AB(C)+BB(J)+SF(M)

[MonkeyF0cker]

=(sum(e3:e999999)+sum(j3:j999999))/(sum(c3:c999999)+sum(j3:j999999)+sum(m3: m999999))

[Chi_archie]

fok me

the think tank is over running PT!!!!!!!

deep shit here sexy mexy!!!!!











thanks again for the brackets contest J.S!!!

[MexicanStallion]

=(sum(e3:e999999)+sum(j3:j999999))/(sum(c3:c999999)+sum(j3:j999999)+sum(m3: m999999))

Appreciate it. Thanks for the help MF

[dj_destroyer]

MexicanStallion... I've been in the process of crafting a sabermetric formula the past few weeks. Mine is a lot more complex with more varied metrics but that doesn't mean squat! We should see if our formulas spit out similar picks or not.

Mine will be ready after 20% of the season but also incorporates last season and the average of the last 5 seasons (not including minors).