Calculating the sum/SUM, SUBTOTAL, sum of multiple columns To calculate the sum of numbers in cells, we can use the SUM function and the SUBTOTAL function. =SUM(number1, [number2…]) [number1] = Select cell range to find the sum for. [number2] = Not obligatory. Select when there is another cell range to find the sum for. Definition・・・