0
The autosum button will insert the function "=sum(...)" and suggest (highlight) a range it finds most likely - usually adjacent cells above, or to the left, of the cell where you insert the formula.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
How do you add the total or a column full of numbers without using a calculator?
Since you put this question in the Excel category, I will answer relative to what you can do with Excel. The quick way is to highlight the column of numbers and click on the Auto-Sum button.
What are several ways to make Sum in Excel?
You can type in the plus sign with individual cells.=A2+A3+A4+A5+A6+A7+A8+A9+A10You can use the SUM function to add the same set of cells.=SUM(A2:A10)You can instigate the sum by using Alt and the equals key. You can also put the cursor under the last cell in a column you want to add or to the right of the last cell in a row of values you want to add. Then click on the Autosum button. You can also select the cells you want and hit the autosum button. You can also use the Subtotal function, with 9 as the initial parameter to tell it to sum.=SUBTOTAL(9,A2:A10)
What is the sum of x x?
Ccv + x + x = 225 The brilliant and witty Wikianswers auto-corrector will not allow me to capitalize the above Roman numerals, per standard usage. Sorry.
What is the sum of a pentacontakaipentagon?
A shape does not have a sum. The angles of a shape have a sum, the lengths of its sides have a sum, the number of its diagonals are a sum, but the shape itself certainly does not have any sum!
What is the sum of CCV X X?
Ccv + x + x = 225 The brilliant and witty Wikianswers auto-corrector will not allow me to capitalize the above Roman numerals, per standard usage. Sorry.
Which toolbar button can you use to calculate your total expenses?
auto sum
What is the path button to auto sum on Excel?
Home Tab/Editing Group
Can you use the Auto Sum button on the Ribbon to quickly insert the Average function?
Yes you can.
What automobile rim manufacture makes EXEL WHEELS that's all it says on the center cap on your rims?
They are made by Exel Wheel Company and not by an auto manufacture.
What is auto sum button and how does it work?
There is a Sigma "∑" buton available on the standard toolbar on the top of the Excel sheet or on the ribbon. It starts the SUM function in a cell, which will select cells to sum up and also allow you to change the selection. So it automatically sums values.
When will you use might use the autosum button in the real world?
Never. You will only ever use the auto sum button when you are using a computer with that facity buit in to the program.
In excel what is the correct formula to auto sum column B?
If you have numbers in cells B1 through B134, use the formula: =SUM(B1:B134). You can use auto sum to insert the formula by highlighting the column (you can click on the column letter) and clicking the AutoSum button on the menu.
Will the Excel auto-sum function automatically find the sums of several columns in a range and put the currect sum below each column?
Yes, you can do that. If you have a series of columns, you can highlight all of the column to select the range. When you click on the auto-sum button, Excel will insert =SUM(XX:XX) at the bottom of each column in the range.
When was Exel created?
Exel was created in 1985.
What is the population of Exel?
Exel's population is 40,000.
How do you produce the sum of a column by using the auto sum function?
Assuming you're using Microsoft Excel, select the entire column by clicking and dragging with the mouse, then press the AutoSum button (looks like Σ).
What is Exel's motto?
The motto of Exel is 'Raising Expectations'.
