answersLogoWhite

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)

User Avatar

Wiki User

12y ago

Still curious? Ask our experts.

Chat with our AI personalities

BeauBeau
You're doing better than you think!
Chat with Beau
LaoLao
The path is yours to walk; I am only here to hold up a mirror.
Chat with Lao
SteveSteve
Knowledge is a journey, you know? We'll get there.
Chat with Steve

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