This article was co-authored by How.com.vn staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for How.com.vn. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 165,743 times.
Learn more...
Need to find the sum of a column, row, or set of numbers in Excel? Microsoft Excel comes with many mathematical functions, including multiple ways to add sets of numbers. This How.com.vn article will teach you the easiest ways to add numbers, cell values, and ranges in Microsoft Excel.
Quick Guide: Adding Numbers in Excel
- Optional: Add numbers to cells in your document (such as A1 and B1).
- Select the cell that should contain the final sum.
- Type an equals sign (=).
- Type an addition equation using numbers or cell references (i.e. 1+2 or A1+B1).
- Press enter to run the formula and see the resulting sum.
Steps
Click the cell in which you want to display the sum.
Type an equal sign =. This indicates the beginning of a formula.[1]Advertisement
Type the first number you want to add. If you would rather add the value of an existing cell instead of typing a number manually, just click the cell you want to include in the equation. Otherwise, you can type a number manually.[2]- For example, if you click cell C3, the value of C3 will be the first number in your equation. If you type 1, the number 1 will be the first number in your equation.
Type a + sign.[3]
Type another number select another cell. This adds the second number or value to your equation.[4]- You can add multiple cells or numbers at once if you'd like—just separate each number or address with another + sign.
- For example, if you want to find the sum of cells C3, D4, and E5, your formula will look like this =C3+D4+E5.
- If you want to add 1 plus 1, your formula will look like this: =1+1 .
- You can add other operations, such as subtraction or multiplication, in the same equation. In this example, we'll add the values of C3 and D4 and then subtract 2: =C3+D4-2
Press ↵ Enter or ⏎ Return. Now you'll see the sum of the added numbers or values in the selected cell.
Click the cell in which you want to display the sum. The SUM function works like using the plus + sign, but is a bit easier to work with when you're adding multiple cells and ranges.
Type an equal sign followed by the word SUM =SUM. This indicates the beginning of the SUM formula.[5]
Type an opening parenthesis (. Your formula should now look like this: =SUM(.[6]
Select the range of cells you want to add. Click and drag over all of the cells you want to add together. For example, if you want to add the values of all cells from A1 through A10, select all of those cells now.[7]- You can also select multiple columns and rows here. To select multiple non-adjacent columns and/or rows, hold down the Control key and as you select each range.
- You don't have to select entire ranges with the SUM function—you can also enter individual numbers or cell addresses.
Type a clothing parenthesis ). This finishes the formula.[8]- Your formula should now look something like this: =SUM(B4,B8)
- In this example, we've selected cells B4 through B8
- If you selected non-adjacent ranges, each range will be separated by a comma. In this example, we selected B4 through C8 (two adjacent columns) and E4 through E5: =SUM(B4:C8,E4:E5)
- Your formula should now look something like this: =SUM(B4,B8)
Press ↵ Enter or ⏎ Return. The sum of the selected range now appears in this cell.
Click the cell immediately below or next to the values you want to add. AutoSum will automatically create a formula that adds the values of an adjacent column or row.[9]- For example, if you want to add the values of cells A:2 through A:10, you would click cell A11.
- You can also add multiple columns or rows at the same time by selecting multiple cells. For example, to display the sums of values in columns A, B, and C, you could select cells A11, B11, and C11.
Click the AutoSum icon on the Home tab Σ. It's the Sigma icon (which looks like an "E") on the Home tab at the top of Excel. A formula will then appear in the selected cell.[10]
Press ↵ Enter or ⏎ Return. Now you'll see the results of the formula in the cell.- If you selected multiple blank cells, you'll see each individual column or row's value in the selected cells.
Common Questions: Adding Up Numbers in Excel
How do I use the SUM formula in Excel?
Click into the cell you want to add the formula. In the formula bar, type =SUM(). Between the parentheses, add the numbers you want to add. You can use cell references and ranges as well.
Can I add an entire column in Excel?
Yes, you can include a cell range in a SUM formula. For example, =SUM(A1:A10) would add together all the numbers in column A from the first to the tenth cell and give you the resulting sum.
How do I subtract in Excel?
You can simply write =#-#, where the # symbol is replaced by numbers or cell references. You can also use the SUM function. Type =SUM(#-#), where the # is again replaced with numbers or cell references. Despite being the SUM function, you can use it to do other mathematical operations besides adding numbers together.
Tips
- Use the SUMIF function to add cells that match certain criteria. For example, if you wanted to find the sum of all cells in A2 through A:10 that are greater than 1, you'd use =SUMIF(A2:A10, ">1").[11]Thanks
References
- ↑ https://support.microsoft.com/en-us/office/add-and-subtract-numbers-c3f02baa-5142-40d6-86e3-70ac0a8de9be
- ↑ https://support.microsoft.com/en-us/office/add-and-subtract-numbers-c3f02baa-5142-40d6-86e3-70ac0a8de9be
- ↑ https://support.microsoft.com/en-us/office/add-and-subtract-numbers-c3f02baa-5142-40d6-86e3-70ac0a8de9be
- ↑ https://support.microsoft.com/en-us/office/add-and-subtract-numbers-c3f02baa-5142-40d6-86e3-70ac0a8de9be
- ↑ https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89
- ↑ https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89
- ↑ https://support.microsoft.com/en-us/office/use-the-sum-function-to-sum-numbers-in-a-range-323569b2-0d2b-4e7b-b2f8-b433f9f0ac96
- ↑ https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89
- ↑ https://support.microsoft.com/en-us/office/use-autosum-to-sum-numbers-543941e7-e783-44ef-8317-7d1bb85fe706
About This Article
1.Use a plus sign to write out formulas like this: =4+5
2.Use the SUM formula to add values from one or more ranges.
3.Use AUTOSUM to automatically find the total of a column or row.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
