sorting formulas with cells
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!
|