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 firstname.lastname@example.org, or fill out the form on our website https://datasciencing.com.