Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Handheld Computing
Hardware
Money Management Software
Multimedia
Office Productivity Software
Operating Systems
Moms, Dads, and Grads -- Win $500!
Excel Timesaving Techniques For Dummies
Adding a "Total" Row in Excel
Adapted From: Excel Timesaving Techniques For Dummies

One of the coolest features of an Excel 2003 list is the ability to instantly add a Total row at the bottom of the list. To do this, click the Toggle Total Row button on the List toolbar after you select one of the cells in the Excel list. The moment you click this button, Excel adds a Total row at the bottom of the list. You can then use this row to total columns with numeric entries by following these steps:

  1. Click the cell in the Total row of the column you want summed.

A drop-down button appears to the right of the cell.

  1. Click Sum on the column's drop-down list, which you can open by clicking its drop-down button.

If you don't want to sum the items in a particular column, you can have the program perform another type of computation, such as averaging the numbers in the column or counting the items (something you can have Excel do even in columns that contain text entries). All you do is select the appropriate type of calculation -- Average, Count, or any of the other available computations -- from the Total cell's drop-down list.


To find out how to have Dummies eTips delivered to your e-mail inbox every week, visit the Dummies eTip Sign-Up Page.
Related Articles
Taking Shortcuts with Macros in Office 2003
Adjusting Columns and Rows in Excel
Totaling Up with AutoSum in Excel
Looking at Error Values and Operators in Excel
Finding the Correct Excel Function
Related Titles
Microsoft Office 97 For Windows For Dummies
Microsoft Office 97 For Windows For Dummies : Quick Reference
Microsoft Office 2000 9 in 1 For Dummies Desk Reference
Microsoft Office 2000 For Windows For Dummies
Microsoft Office 2000 for Windows For Dummies: Quick Reference