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

Check if your reference is absolute.
See help for "Switch between relative, absolute, and mixed references"


---Please click "yes" if this post helped you!---

Greatly appreciated
Eva


"ram" wrote:

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

This occurs when the formula references the current sheet inside single quotes (i.e., 'current tab'!A1). If you change the reference to be simply A1, the issue should be resolved.

On Monday, February 15, 2010 4:55 PM ram wrote:

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 does not change however, the other column do
change.

Is this normal or am I doing something wrong?

Thanks for any help


On Monday, February 15, 2010 5:53 PM Eva wrote:

Check if your reference is absolute.
See help for "Switch between relative, absolute, and mixed references"


---Please click "yes" if this post helped you!---

Greatly appreciated
Eva


"ram" wrote: