Formula for connecting multiple sheets and cells

[Guppy1203]

Hello,

I am using a spreadsheet for a weekly football league. I would like "Sheet 1" to have the picks for the current week with the point total at the bottom for each team (I have that set up), but on a different "Sheet" I would like to keep a running total for each team. I know how to creat a formula for the total points, but how do I get that formula to attach to the corresponding column on the same row.

EX:
A B
"Team Name" "Formula for total points"

I would like A and B to stay connected when I auto arrange them in numerical order. Can anyone help me?

 

[AlphaFrog]

You would have to better describe the layout of Sheet1.

You might be able to use the SUMIF or SUMIFS functions.

Here's a comprehensive Football Pick template. It may give you inspiration. You probably could find several other templates by doing a web search.