Excel 2007 : Sum Rows to repeat at Bottom

[NikJSD]

Does anyone know how I can set up a spreadsheet that automatically calculates the totals at the bottom - moving down automatically as new rows are populated - Without having to insert new rows and re-do the SUM function to include the new data???

[Haseeb Avarakkan]

Convert your range to Table,

See the link.

http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx