I am using excell 2003 and I am trying to sort my sales for the year by
column. I can sort fine however the formulas aren't moving with my sort so
some of my numbers are off.

Example:

A 5
D 7
C 1
B 8
E D+C

After sort

A 5
B 8
C 1
D 7
E B+C

This is really messing with the reports that I am trying to generate using
this formula so if anyone can help me I would greatly appreciate it.