Excel SUM function allow you to sum row or columns and display the answer is the selected block of excel where you have applied the formula.
Summing all these values is made is by excel by using the sum function.
The Formula for sum function is =SUM(Number1,number2...)
Instead of numbers you can select the Row or columns in which all the number you want to sum are contained.
Example:
For the sum of all the values to appear in B19 cell of the excel select the B19 cell and write this =SUM(A1:A17) in the function bar. And press enter.
The Sum of all these values will appear in B19 cell.
Summing all these values is made is by excel by using the sum function.
The Formula for sum function is =SUM(Number1,number2...)
Instead of numbers you can select the Row or columns in which all the number you want to sum are contained.
Example:
For the sum of all the values to appear in B19 cell of the excel select the B19 cell and write this =SUM(A1:A17) in the function bar. And press enter.
The Sum of all these values will appear in B19 cell.
No comments:
Post a Comment