Sorting with sumif function

R

ram

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
 
E

Eva

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
SUMIF Function 2
function help, sumif?? 2
sumif functions 4
nesting sumif functions 5
SUMIF function 3
quick question on sumif 3

Top