sum-if & sorting

  • Thread starter Thread starter markholt
  • Start date Start date
M

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
 
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.
 
=SUMIF('1-27-10'!I$1:I$824,$K2,'1-27-10'!D$1:D$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??
 
Back
Top