Tournament Spreadsheet

I am having trouble with my tournament spreadsheet. It is for a fishing tournament and its based over 5 tournament with the lowest score getting dropped at the end of the year. Column H is total points {=SUM(C5:G5)-MIN(C5:G5)} now in column G i want it to display points behind. I tried using this formula {=SUM(H5)-H6} it works fine but when i want to copy it down to all the below cells i cannot drag it without it changing to {=SUM(H6)-H6} and {=SUM(H7)-H7} and so on and so on. Is there a better way to do this. also the columns are labled and filtered for easy access such as:
Member Scrren Name tournament1 tournament2 tournament3 tournament4 tournament5 Total Points Points Behind Place Points per place


Sometiems when i arrange the columns the formula gets screwed up. Is there anything i can do to fix this?

You don't need the SUM function in there. If you want the H5 term not to change when you copy it down, do it like this:

=H$5-H6

Hope this helps.

Pete

Sorry i didn't realize that {} was something that was used in excel. i simply used that to bracket the formula. the {} are not in use in the formula