sorting range changes sum??? (excel)

[bertbarndoor]

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)

See answer in worksheet functions - and please don't multi-post.

Andy.

"bertbarndoor" <[email protected]> wrote in message
news:[email protected]...
> 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)
>