I'm working on formula on one sheet that reference another sheet. If I use
sum and I drag the cells I get a1:a4. I can click one each cell
independently and get a1+a2+a3+a4 but none of these are absolute. I've
tried using paste special but it kicks me out of the original formula. I
have spent to much time trying to make sure the values are absolute.

Marc

<Andy B wrote in message ...
Hi
If I understand you correctly (forgive me if I don't!) you can use Copy
and
Paste Special Values on sums in exactly the same way as references. An
alternative is to select the cell(s) and hit F2, F9, Enter.

--
Andy.


"Marc" wrote in message
link.net...
Many of my references link to another work sheet and "paste special"
gives
me absolute values but you can't at least that I know of use these
easily
in
"sum".

Marc