Select Page

Let’s Have Data Fun with Excel: Auto Total

by | Nov 5, 2020 | Uncategorized | 0 comments

Let’s imagine you have a column of values in your spreadsheet and you need to easily calculate the total of all those values, aka figure out the sum.

What you can do is, select all your values in the column and add an extra cell at the bottom.

Next, on your keyboard hold down the ‘alt’ key and press the equal ‘=’ sign.

Go to the bottom, to our extra cell. And you see it automatically created the sum formula for all your rows here. This is the total for all the values in this column.

This will also work if you need the total of a row of values.

Again, we select all our cells we want to calculate. Add an extra cell at the end.

Hold down ‘alt’, press equal ‘=’ and there’s the formula.

If you need help with your Excel spreadsheets, I’m Peter Koebel the owner of Data Sciencing Consultants. You can reach me at 204-770-6437, or email me at, or fill out the form on our website  

Looking for more fun with data? You might enjoy some of our other posts!

Survivorship Bias in Business

Survivorship Bias in Business

What is your company doing to not get duped by the survivorship bias trap? I’ll give you a classic example of survivorship bias. You might recognize this picture if you’ve studied survivorship bias, statistics, or data visualization. In World War 2 the U.S. Military...