Q&A for How to Use the Sum Function in Microsoft Excel

Return to Full Article

Coming soon

Add New Question

Question

How can I create a source data using auto sum for the total?

Community Answer

The function =SUM(Column and row to start, Column and row to end) in the cell you wish. E.g., =SUM(B2:B7).

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 14
Question

How do I use the Sum function to add cells B5, B6, B9, B11?

Community Answer

=SUM(B5, B6, B9, B11).

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 5 Helpful 27
Question

How do I add a cell to a sum formula?

Community Answer

You can use =SUM(A1, B1). If you already have the above, find the name of the cell, add a comma to the end, and type in the name. An alternative to these is to type "=SUM" and then click and drag the items you would like to be included. Don't forget the closing parenthesis!

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 10
Question

What is the formula to subtract a sum of cells from another cell?

Community Answer

=A1-SUM(A2:A10) This would work if the numbers you are trying to subtract are in cells A2 through A10 and the number you are subtracting from is in cell A1.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 4
Question

How do I tell if autosum has been used in excel or if it was done cell by cell?

Community Answer

If autosum was used, changing one of the numbers in the column being added will automatically change the sum as well. Check by changing one of the numbers and seeing if the sum changes.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 4
Question

How do I get averages in auto-sum?

Community Answer

In Excel 2010, in the Folmulas menu, click on the AutoSum symbol and select Average.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 2
Question

The sum line and the top of my spreadsheet is missing, how do I get it back?

Community Answer

Use the Escape key. Close the program without saving the file, and restart. When you reopen the file, it should be there; otherwise, you will have to rewrite the sum line.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 3 Helpful 1
Question

How do I use the auto sum calculation in MS Excel?

Community Answer

Click into the cell end the of the cell that you want to add, and press alt and = (auto sum).

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 2