If A21 is a carry-over from the previous column of calculations, maybe
you'll want to make it absolute also:

=Sum($A$21,D$1:D1)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

wrote in message
om...
Yes it worked great but when I try a similar formula in column D it doesnt
work
=SUM(A21,D$1:D1)