answersLogoWhite

0


Best Answer

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)

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are several ways to make Sum in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

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.