Many Thanks !! Ciao Bruno, It works !!



"Bruno Campanini" wrote in message
...
"Ellis Yu" wrote in message
...
Dear All,

I've a sum function to add up a column from row 50 to row 100
like
"= sum(A50:A100)". If I delete the rows between this range, let's say we
delete 3 rows. It will become "=sum(A50:A97)". Even I use absolution
address, the result is the same. I just want to add up the values from
row
50 to row 100, no matter making any change in the row. Any idea? Thanks

Best Rdgs
Ellis

Try:
=SUM(INDIRECT("A50:A100"))

Ciao
Bruno