0
The proper way is:
=SUM(A1:B1)
Though you would hardly ever see any of them, it could also be done in these ways:
=SUM(A1,B1)
=SUM(A1+B1)
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What is a common function in Excel?
The most basic function in Excel is SUM() Other functions are AVERAGE, MIN, MAX
What is a sum in Excel?
SUM() is a function within Excel which adds up the values of the cells that are passed to it. You can pass individual cells, a list of cells or a range of cells. e.g.=SUM(A1) returns the same value as the cell A1=SUM(A1,B2) return the sum of A1 + B2=SUM(A1:B2) returns the sum of the range A1:B2Ranges are effective squares of cells, so the range A1:B2 is a small 2x2 square consisting of A1, A2, B1 and B2.
What is the formula to find the sum of cells a1 a2 and a3 in excel?
Excel formulas that will find the average of cells A1, A2, and A4 are: =AVERAGE(A1 ,A2, A4) or =AVERAGE(A1:A2, A4)
What are the different ways to total values in Excel?
Basically you can either add values individually, including cells: = 1 + 2 + 3 or, to add values in cells: = A1 + A2 + A3 Or, you can add a range of numbers, stored in adjacent cells, with the sum() function: = SUM(A1:A10)
Which excel feature will display the sum of all the selected cells?
Enter =sum(A1:A20) in the cell that you would like to display the sum, where A1:A20 is the range of cells you would like to add.
What is the sum function on spreadsheets?
SUM function is use to aggregate in MS Excel Suppose you want to sum values from A1 to A10 in A11, type = SUM(A1:A10)
Can a function be an argument in another function in Excel Microsoft?
If the function allows multiple arguement, you can use another function within most functions. EXAMPLE: =IF(SUM(A1:A14)>120,SUM(A1:A14),"Oops! not enough")
What function do you use to add the value of cells at one go?
SUM - If you want to add the values of cells A1 through A23, use =SUM(A1:A23).
What are the equations in Microsoft Excel?
Equations perform some type of operation.EXAMPLE:Find the sum of all numbers in the cells A1 through A23.The formula is =SUM(A1:A23)
Which formula can add the all the numeric values in a range of cells ignoring those which are not numeric and place the resulting a difference cell?
The alphanumeric values will already be ignored during a calculation in Excel sheet. So, any formula works. For example, if you got to take out the sum of cells A1 to F1, write =SUM(A1:F1).
How would you add two entire worksheets in excel?
If you have numbers on two worksheets in cells A1:C23, you can use the formula:=SUM(sheet1!A1:sheet1!C23)+SUM(sheet2!A1:sheet2!C23)
What is a formula in Microsoft Excel?
A formula in Microsoft excel is like a formula in real life, like a math equation or math problem (ie. 2+2=4). You write the Excel formula like this: =2+2Actually it is more like =A1+A2 Or =SUM(A1:D2)The SUM is a Function the A1 -> D2 is The RangeAnd the : is the argument. When you have =SUM(A1:D2)you are adding the cell from A1 -> D2 so you are adding them together
