Then we need to press the Enter key to complete the SUM function. In a cell “F25”, click “Alt + =” Excel SUM formula will be appearing in the active cell along with cell reference. In a range of cells, it contains sales data between cells F20 to F24 I need to apply an auto sum function for that range. The keyboard shortcut for AUTOSUM: Alt + = Numbers in a range of cells can be quickly added by using AUTOSUM Option in Excel. The SUM function returns the value or total sales data, i.e. I11:I15 range represent fourth-quarter sales data H11:H15 range represent third-quarter sales data G11:G15 range represent second-quarter sales data Where F11:F15 range represent first-quarter sales data In the SUM formula, we need to specify four separate ranges in the argument & is separated by a comma i.e. We have to simply specify the first and last cell in a range of cells to be added up for each quarter or column. Here, we need to find out the total sales from four-quarter sales data. In the excel sheet, company quarterly sales data is present in each column. All the cells in all the ranges are added together to give a grand total. The below-mentioned example will add up several or multiple ranges of cells at once.
In the earlier examples of the SUM Function, we have only added up to one range at a time.
In the argument, fraction values “6/2” & “4/2” need to add & is separated by a comma. SUM formula is applied in cell “F6”, i.e. In this example, I want to apply the sum function for fraction values “6/2” & “4/2”. In the argument, cell references ‘B21’, ‘B22’ and ‘B23’ needs to added & is separated by a comma. =SUM(B21, B22, B23) here, We have to select the cells that contain the decimal values we want to add together. SUM formula is applied in cell “C21”, i.e. In this example, an Excel sheet with the cell references ‘B21’, ‘B22’ and ‘B23’ contains the decimal values. In the argument, the cell references ‘B15’ and ‘B16’ needs to added & is separated by a comma. =SUM(B15, B16) here, We have to select the cells that contain the values we want to add together. SUM formula is applied in cell “C15”, i.e. In this example, an Excel sheet with the cell references ‘B15’ and ‘B16’ contains the value ‘3’. It returns the total quarterly sales value as 3398