Hi

Is there anything specific about those cells? Are they all the same month,
the same salesman, the same product? If so, you can sum using SUMIF or
SUMPRODUCT - whether they are sorted or not. It is very dodgy summing
information by where it is on the sheet!

Andy.

"bertbarndoor" wrote in message
oups.com...
Hi, this is probably simple to fix, but after googleing for a while, I
still haven't found it. I have a formula on a worksheet that includes a
sum of a range of data on another worksheet. When I sort the column of
data on the other worksheet, the sum changes on the other 'report'
worksheet as the range now contains different data. How can I get excel
to sum the specific cells in the original range (short of selecting
each cell with the ctrl key) and maintain focus on those cells, even
after a sort might disperse them all over the column? Thanks,

Rob


sorting range changes sum??? (excel)