Hello, experts, I want to learn that how I can use Microsoft Excel SUM Formula for calculating the value between two rows or column. Kindly guide me to the steps for using the formula. Thanks in advance for the help.
SUM function in Excel called as Worksheet function (ES).
Syntax:
If you want the sum of numbers (by explicitly):
SUM( number1, number2, …. , number n)
If you want to sum in Cell manner:
SUM( cell1: cell3 )::: This will print the sum after adding the content of Cell 1, Cell 2 and Cell 3
=SUM( A2 , A3 ) = 17.7
The SUM function in Microsoft Office Excel is easy to use. The function simply adds all the numbers in a range of cells. The range of cells to add depends on the cells you select. To use the SUM function, select the cell where you want the output to appear.
On that cell, type without quotes “=sum(” then press and hold the CTRL button and then select the cells you want to add. The cells you select don’t have to be on the same row or column.
After selecting all the cells to add, type without quotes “)” then hit Enter. The close parenthesis closes the formula then the formula is executed once you hit the Enter key.
