sum-if & sorting

[markholt]

My file has several sum if formulas. It seems that the formulas change
themselves (the field scope ?? not sure that's the right word..) but I use
the dollar sign & copy down. It works great. But during the time I use the
file & sort & resort it the formula changes itself.

Is there a way to keep this from happening??

Mark

 

[Luke M]

Can you give us an example of the formula?

If the boundary edge of your range is within the sorted data, it can cause
problems.
Example:
Formula is =SUMIF(A$4:A$7,A$9)
but your sort range A2:A10. The cells your were looking at have now posibly
moved outside your formulas range.

 

[markholt]

=SUMIF('1-27-10'!I$1:I$824,$K2,'1-27-10'!D$1$824)

** my sorts are using the - formula bar's "Data sort AtoZ or ZtoA"

I tried making my file 1500 records & filling the records from my data to
1500 with the letter "Z" to fill the file - because I know the sort function
AtoZ doesn't like empty fields ...

The formula above was a 1500 long formula - then excel made it 824 - make
sense??