Many Ways to Sum a Column in Excel

Key to Instructions
To help readers follow the instructions in this article, we use two different typefaces.
Boldface type identifies the names of icons, agendas, URLs and application commands.
Sans serif type indicates instructions and commands that users should type and file names.

Q. One of my colleagues told me there are a hundred ways to add numbers in Excel. Is that true?

A. There are quite a few ways, but a hundred may be an exaggeration. Here are my favorites—one using keystrokes and the other using the mouse:

Keystrokes: If you want to get the sum of cells B5 to B12, you could use the slow way by writing out the full formula:


Or you could evoke the shortcut and click on B13, hold down the Alt key, type in = and then press Enter.

Mouse: Place your cursor on B13 (one cell below the column you are adding) and click on the AutoSum icon: , producing this screen (notice the shortcut actually generates the same full formula):

Then press Enter.

While you’re at the AutoSum icon, click on the adjacent arrow and take note of the other quick functions you can perform (see screenshot below left). It’s a very handy button.

And you’ll find even more helpful functions if you click on More Functions (see result in screenshot at right).



2019 State of Financial Reporting Survey

We surveyed nearly 600 finance and accounting professionals on their month-end close and reporting processes. See the results.


What RPA is and how it works

Robotic process automation is like an Excel macro that can work on multiple applications, says Danielle Supkis Cheek, CPA. RPA can complete routine, repetitive tasks such as data entry, freeing up employee time from lower-level chores.