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

11y ago

Still curious? Ask our experts.

Chat with our AI personalities

RossRoss
Every question is just a happy little opportunity.
Chat with Ross
DevinDevin
I've poured enough drinks to know that people don't always want advice—they just want to talk.
Chat with Devin
JudyJudy
Simplicity is my specialty.
Chat with Judy

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