The Microsoft Excel SUM function sums or adds all numbers which are in a range of cells and returns the result.
Syntax
The syntax for the SUM function in Microsoft Excel is:
SUM( number1, [number2, ... number_n] )
OR
SUM ( cell1:cell2, [cell3:cell4], ... )
Excel sum function would return the number after adding the range, and excel sum formula can be done as a excel sum shorcut like AutoSum which is a fast, easy way to add up multiple values in Excel.
Excel Sum Formula Example
The above example would return 30,000 as the range can be selected like this sum(A2:A7) which would add the excel sum of columns in the result.
Excel-Xpert is a all about excel, a professional series where everyone would get a chance to participate and we would try to explore and find new things, this would serve people who are keen to learn excel in detail.
Subscribe to:
Post Comments (Atom)
Excel formulas and functions
Excel formulas and functions Formulas and functions are the bread and butter of Excel. They drive almost everything interesting and useful...
-
Excel Dashboards would be covered in our excel tutorial today. We will create Excel Dashboards and learn the following skills in our excel T...
No comments:
Post a Comment