![]() 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
0 Comments
Leave a Reply. |