When you are working with lists in Excel, use the built-in Table feature, to make it easier to work with the data.

Then, use the built-in Total Row function, to quickly add totals to one or more of the columns. Choose from 11 functions, such as Sum, Average, and Count.

The Total will automatically update if rows are added to the table, without any changes to the referenced cells.

Watch this short video to see the steps.

Visit this page to get the sample file and written instructions.
http://www.contextures.com/xlexceltable01.html

Please take the opportunity to connect and share this video with your friends and family if you find it useful.