I'm having trouble with what seems like an easy problem. How come when I
sort my data, the forumlas I have in it don't stay relative? For example, I
have

Seattle Washington 14
Olympia Washington 27
Dallas Texas 8
Austin Texas 11

I've got the Washington numbers adding and the Texas numbers adding at the
bottom of my page (C1+C2). But when I sort to alphabetize the city, the
formula is still adding C1+C2, not Seattle + Olympia.

Austin Texas 11
Dallas Texas 8
Olympia Washington 27
Seattle Washington 14

How do I keep the formula linked to the contents, and not the cell location?

Thanks!