0
A minimum of one argument is needed and you can have up to thirty. Though the answer would be obvious, you can use a single value in a SUM function like this:
=SUM(5)
You can also use a single cell:
=SUM(A23)
It can also be another calculation or function, though these can be done without using the SUM function:
=SUM(A5*10)
=SUM(AVERAGE(A24:B30))
Wiki User
∙ 9y ago
Wiki User
∙ 10y agoUp to 30 arguments can be used.
Add your answer:
Earn +20 pts
What are three parts of a function in Excel?
You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.=NAME()=NAME(arguments)The TODAY function has no arguments so it can be entered like this:=TODAY()The SUM function must have arguments, so it could be something like this:=SUM(A2:A20)You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.=NAME()=NAME(arguments)The TODAY function has no arguments so it can be entered like this:=TODAY()The SUM function must have arguments, so it could be something like this:=SUM(A2:A20)You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.=NAME()=NAME(arguments)The TODAY function has no arguments so it can be entered like this:=TODAY()The SUM function must have arguments, so it could be something like this:=SUM(A2:A20)You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.=NAME()=NAME(arguments)The TODAY function has no arguments so it can be entered like this:=TODAY()The SUM function must have arguments, so it could be something like this:=SUM(A2:A20)You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.=NAME()=NAME(arguments)The TODAY function has no arguments so it can be entered like this:=TODAY()The SUM function must have arguments, so it could be something like this:=SUM(A2:A20)You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.=NAME()=NAME(arguments)The TODAY function has no arguments so it can be entered like this:=TODAY()The SUM function must have arguments, so it could be something like this:=SUM(A2:A20)You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.=NAME()=NAME(arguments)The TODAY function has no arguments so it can be entered like this:=TODAY()The SUM function must have arguments, so it could be something like this:=SUM(A2:A20)You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.=NAME()=NAME(arguments)The TODAY function has no arguments so it can be entered like this:=TODAY()The SUM function must have arguments, so it could be something like this:=SUM(A2:A20)You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.=NAME()=NAME(arguments)The TODAY function has no arguments so it can be entered like this:=TODAY()The SUM function must have arguments, so it could be something like this:=SUM(A2:A20)You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.=NAME()=NAME(arguments)The TODAY function has no arguments so it can be entered like this:=TODAY()The SUM function must have arguments, so it could be something like this:=SUM(A2:A20)You could say the name, the brackets and the arguments. All functions will have a name and brackets. For most functions there will be something inside the brackets, known as arguments, although some functions have no arguments. Here are the two forms.=NAME()=NAME(arguments)The TODAY function has no arguments so it can be entered like this:=TODAY()The SUM function must have arguments, so it could be something like this:=SUM(A2:A20)
What is the difference between argument and function in Excel?
A function is a built-in formula in Excel designed to do a particular task. Arguments are values that you provide to a function to do its task, like cell address that hold numbers that you want to use for the function. For example, the numbers and addresses in the following SUM function are arguments: =SUM( A2:A5, 7, 800, B18 )
What is the formula for arithmetic sum?
=sum()
What must be included around the argument in a function?
Arguments are enclosed in brackets. One set of brackets applies for a function, no matter how many arguments there are. So in a list a particular argument could have other arguments around it, all separated by commas. Here is the SUM function with one argument: =SUM(A2:A20) The IF function has 3 arguments: =IF(A3>50, D2*10, D2*20)
WHAT IS FORMULA OF AVERAGE?
SUM/TOTAL
What is the formula for the sum of polygon?
lengthxwidth
In using excel how do you decrease a formula?
I am not sure what you are asking, since I have never heard the term "decrease a formula," but my best guess is this:Assume you have a formula =SUM(A1:A23) and you want to decrease the sum by 6, you would enter the formula =SUM(A1:A23)-6.
The formula for finding the sum of the angles of a polygon?
The formula for finding the sum of all angles of a polygon is: N = number of sides (N-2)180 = The sum of all angles
What is the sum of all charges in the formula for an ionic compound?
This sum will be zero.
Sum of sides of a polygon?
There is not a general formula for the sum of the sides of an arbitrary polygon.
How many 4 digit numbers can be made to give the sum of 6?
If repetition of digits is allowed, then 56 can.If repetition of digits is not allowed, then only 18 can.
What is the equation for the angle sum formula?
The sum of the interior angles of a polygon with n sides is (n-2)*180 degrees The sum of the exterior angles of a polygon is 360 degrees, however many sides it has.
