How to sum a column in google sheets
By
SpreadCheaters
Page last updated:
19/04/2023 |
Next review date:
19/04/2025
You can watch a video tutorial here.
If you want to get the sum of a number of values in a column we use the SUM formula.
Step 1 – Click on a cell where you want the result to be displayed and type “=SUM(“, and then add the range of values you would like to get the sum of. For example “=SUM(B2:B4). Typically the sum would be at the base of a column of numbers but it can actually be anywhere in the Google Sheet.
– Click on a cell where you want the result to be displayed and type “=SUM(“, and then add the range of values you would like to get the sum of. For example “=SUM(B2:B4). Typically the sum would be at the base of a column of numbers but it can actually be anywhere in the Google Sheet.
Step 2 – When you now press enter the sum will be displayed rather than the formula. Note how the formula is still displayed in the formula bar as B5 is still highlighted.
– When you now press enter the sum will be displayed rather than the formula. Note how the formula is still displayed in the formula bar as B5 is still highlighted.
