HI,

I have a worksheet with 5 columns of data and 100 rows. in one of the
columns I have a sumif formula. When I try to sort the data the cell
reference in the sumif column doesn't change however, the other column do
change.

Is this normal or am I doing something wrong?

Thanks for any help