This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. 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, fictionwriting, and zinemaking at various institutions.
The wikiHow Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 109,277 times.
This wikiHow teaches you how to use the SUM function to add two cells containing other SUM formulas in Microsoft Excel. If you get an error when trying to add your two cells, it's usually because one of your original formulas contains additional characters or multiple functions. You can fix this by placing such formulas inside of the =VALUE() function.
Steps Download Article

1Open your spreadsheet in Microsoft Excel.

2Add =VALUE around the formulas in the cells you're adding together. If the cells you're adding together use formulas that contain nonnumeric characters, then you'll need to add =VALUE at the start of those formulas.
 If either of the cells you're adding contains anything other than the standard =SUM() formula, you'll have to enclose that whole formula within the parentheses of the =VALUE() function to avoid errors. Do the following in each of the cell you're adding:^{[1] X Research source }
 Doubleclick the cell containing the formula.
 If the formula is standard, such as =SUM(A1:A15), you don't have to make any changes.
 If the cell contains other functions (such as IF or AVERAGE), letters, or quotes, enclose the formula within the parentheses of the =VALUE() function.
 For example, =SUM(AVERAGE(A1:A15),AVERAGE(B1:B15)) would become =VALUE(SUM(AVERAGE(A1:A15),AVERAGE(B1:B15) )).
Advertisement 
3Click an empty cell. This is where you'll enter the formula that adds the other two cells together.

4Enter the SUM formula. Type =SUM() into your selected cell.

5Enter the names of the cells that contain the sums you want to add. You'll enter these two cell names (e.g., A4 and B4) inside the parentheses, separated by a comma.
 For example, if you're adding the values of cells A4 and B4, your formula should look like this:=SUM(A4,B4)

6Press ↵ Enter or ⏎ Return. This adds the values of the two cells and displays the sum.
 If the value of either of the two added cells changes, the result of your new formula will also.
 You can update all formulas on the sheet by pressing F9.
Advertisement
Community Q&A
Tips
 This process will also work for other formulas (e.g., adding together two cells which contain products of multiplication).Thanks!
Warnings
 Remember to save your changes before exiting Excel.Thanks!
References
About This Article
1. Fix any issues with the original formulas.
2. Click an empty cell.
3. Type =SUM().
4. Type the cells between the parentheses separated by commas.
5. Press Enter or Return.