At the same time, you want to make sure that in case any new value is added anywhere in the column, it’s also added to the total value.īelow is the formula that will do this: = SUM ( A:A ) Sum an Entire Column using the SUM FunctionĪnother thing you can do when calculating the sum of all the values in a column is to include the entire column as a part of the formula.įor example, suppose you have the data as shown below and you want to add all the values in the entire column.
In case a value is added to these cells, the formula would automatically update to reflect these new values in the total sum. In our example, I can use the below formula instead: = SUM ( A2:A14 )Īlthough cell A11 to A14 are empty as of now, these are still used in the formula. Instead of just using the range that has the values, you include more cells that might get some additional data in the future. While you can adjust the formula, there is a better way to make the formula dynamic.
While this works great, what if your data expands and you get new values that you need to be a part of the sum. Since this is a dynamic result, in case you change anything in any of the cells, the formula would automatically update. When you enter the text =sum and then hit the tab key, Google Sheets will automatically select the range of cells that have the numbers.
Google Sheets try to guess the range for you which you want to calculate the sum. Suppose you have the dataset as shown below and you want to get the sum of all the values in the column.īelow is the formula that will give you the sum of all the values in the column: = SUM ( A2:A10 )Įnter this formula in cell A15 (or whichever cell where you want the sum of the column) and hit the enter key. Sum an Entire Column using the SUM Function.