EXCEL:How do you sum automatically columns with dynamic numbers that change (like more row can be added/delete?

I have 3 sections on 1 sheet. They are sectioned via row data. So after every few rows section 2 will start, then 3, etc. I am pulling numbers from a database with Excel, The number of row and their amounts change. So I could have 5 rows of numbers one day and 2 rows of numbers the next. I manually have to type the word TOTAL and SUM up the column. I am wondering if there is a way to SUM up dynamic content. EXCEL:How do you sum automatically columns with dynamic numbers that change (like more row can be added/delete?
could you provide more detail.


you have a column with 3 sections of rows? so that would rule out the obvious





=sum(a:a)





what separates section section 1 form 2 from section 3?


if there is a column that states ';section 1'; in every row that belongs to section 1...then that makes everything real easy...you can use the sumif() formula


- or you could name your ranges and use a ';dynamic named range';





http://www.cpearson.com/excel/named.htm





or





http://www.ozgrid.com/Excel/DynamicRange鈥?/a>





hope it helpsEXCEL:How do you sum automatically columns with dynamic numbers that change (like more row can be added/delete?
Use a blank row at the beginning %26amp; end of the data you're adding. Include the two blank rows in your formula %26amp; pull the data into the rows between them.





Since you then won't be deleting the first blank row %26amp; the last blank row your formulas will adjust automatically as rows are inserted and deleted.





B2: (blank)


C2: 10


D2: 20


E2: 20


F2: (blank)


G2: Formula =SUM(B2:F2) wil return 50, delete E2 %26amp; number will change to 30 automatically.