Select Page

Excel Video 395 shows you an easy way to put a total row at the bottom of your table. With one click, you can add a total row to the bottom of your table. Even better, Excel will include a drop-down box for you to automatically create formulas in the total row. It’s easy to calculate sums, counts, and averages for your data, as well as maximum and minimum values, all without writing any formulas. Each column can have a different formula.
If you have people in your office who aren’t very comfortable writing formulas in Excel, use the total row to make their lives much easier. It’s a great way to get people a little more comfortable using Excel.
Stay tuned. Next time I’ll tweak these formulas a little to make them even more useful. Thanks for watching.