0
You can type in the plus sign with individual cells.
=A2+A3+A4+A5+A6+A7+A8+A9+A10
You 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)
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
How many different ways are there to add prime numbers to make a sum of 12?
It would be 5 ways
How many ways can you make six with the sum of three digits?
Using only positive digits, and disregarding their order, 3 ways.
What other n number of unit fractions can be found that sum to 1?
There are infinitely many different ways to make groups of fractions that sum to 1.
How many different ways are there to add prime numbers to make a sum of 15?
Eight different ways.Eight different ways.Eight different ways.Eight different ways.
What is an ict formula?
an ict formula is something that can caluculate a sum faster than usuall, it will work out the sum ,, and the software that is used is Microsoft excel.
What do you need in a excel cell to calculate a sum?
You need a formula. That formula can use the Sum function or it could use the plus sign, or several plus signs and even several Sum functions. Primarily it is the Sum function and the plus sign that is used for sums.
What following functions was new in Excel 2007 sum ifs sum if count if or sum?
SUMIFS was new in Excel 2007.
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.
What is the sum function for cells A-1 to B-1 in excel?
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)
What is the sum of 65381204?
A sum is made with a combination of several numbers - a single number cannot make a sum.
What do you use to sum a large range of data in Excel?
The SUM function.
What is the sum of 7 and 4 in Excel spreadsheet?
The sum of 7 and 4 is 11, whether in an Excel spreadsheet or anywhere else. In Excel the formula would be =SUM(4,7) or =4+7 or =(B12+B13) if the values 7 and 4 were in cells B12 and B13.
How many different ways are there to add prime numbers to make a sum of 12?
It would be 5 ways
What is the sign of sum in Excel?
The representation of SUM is the capital Greek letter SIGMA (Σ).
What are some examples of Excel formulas?
formula's of excel =sum(+_/*) =count(if) =today() =now() by' (rubab)
When was Sum ifs introduced to Excel 2007?
The SUMIFS function first appeared in Excel 2007. The previous version, Excel 2003, did not have it.
How do you add 2 values in Excel?
The 'sum' function.Type =sum(X,Y) - bold for emphasis - where X and Y are your cell locations or values, and Excel will return the sum (i.e. the result of addition) of those values.
