How to use AutoSum in Excel. AutoSum works best when you have a column or row of numbers you want to add up. 1. Click the empty cell underneath the column of numbers that you want to add up.

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows.