Problem occur in sum function while deleting the rows

E

Ellis Yu

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
 
B

Bruno Campanini

Ellis Yu said:
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
Click to expand...

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

Ciao
Bruno
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with LARGE function 3
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 2
function returning SUM of 2 adjacent cols in 2 separate cells 7
Sum of different value in different worksheet & cell number 2
Using SUM + INDEX in array formula 5
Inserting Rows and the affect on Functions 3
How to add only the adding filtered result using SUM function? 7
Sum the first x cells in a range 10

Top