yogi_Sum 5 Weeks Of Scores And Total Of All Data By Team

                                           Google Spreadsheet   Post  #831
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Oct 26, 2012
user tony.cc said: (http://productforums.google.com/forum/?zx=r3nme9qg99cb#!category-topic/docs/spreadsheets/AmOUfc_cXIo)
sum function
I am trying to enter a sum function  into a league standings sheet with totals from sheets week 1 c6,week 2 c9,week3 c12,week 4 c15,week 5 c18.

week 1 12 points  =12 points

week 2  8  points  =20 points.

week 3 14 points  =34 points.

week 4 16 points  =50 points.

week 5 22 points  =72 points.

So the question is can i enter into sheet 6 the sum value from the other 5 sheets on a weekly basis. 

---

https://docs.google.com/spreadsheet/ccc?key=0An0cXkWSFeKIdHRrLS1INUlKc0pTWE52NGQ0aG9YZEE#gid=0

-------------------------------------------------------------------------------------------------

following is a solution to the problem based on my understanding of tony.cc's requirements