- Select the data (A1:F15).
- Choose Subtotals from the Data menu. Excel will default to the Date value in column A for changing.
- If necessary, choose Sum from the Use Function drop-down list.
- In the Add Subtotal To list, check both Total and Decimal (you want subtotals for both columns).
- Click OK.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.