How to Add Two Cells Containing the Sum of Other Formulas in Excel

Find the total of two SUM formulas in a new cell

Written by Darlene Antonelli, MA

Last Updated: November 13, 2024 Fact Checked

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 the =VALUE() function.^{[1]
X
Trustworthy Source

Microsoft Support
Technical support and product information from Microsoft.

Go to source}

Adding Two Cells Containing Other Sum Formulas in Excel

Open the Excel spreadsheet and click on an empty cell.
Type =SUM() into the empty cell.
Type the names of the cells you want to add together between the paragraph symbols in the =SUM() formula and press "Enter" to generate the new total.

Steps

Download Article

To do this, double-click the Excel document that contains your data in Finder (Macs) or File Explorer (Windows). Alternatively, if you already have Excel open, click File > Open and select the file that has the data you want to add.
2
Add =VALUE around the formulas in the cells you're adding together. If the cells you're adding together use formulas that contain non-numeric characters, then you'll need to add =VALUE at the start of those formulas in order to use the SUM function.^{[2]
X
Trustworthy Source

Microsoft Support
Technical support and product information from Microsoft.

Go to source}
- 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:
- Double-click the cell containing the formula.
- If the formula is standard, such as =SUM(A1:A15), you don't have to make any changes.^{[3]
  X
  Trustworthy Source
  
  Microsoft Support
  Technical support and product information from Microsoft.
  
  Go to source}
- 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
This is where you'll enter the formula that adds the other two cells together.
Type =SUM() into your selected cell.
5
Enter 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.^{[4]
X
Trustworthy Source

Microsoft Support
Technical support and product information from Microsoft.

Go to source}
- For example, if you're adding the values of cells A4 and B4, your formula should look like this:=SUM(A4,B4)
- If you're adding a range of cells, like an entire column, enter =SUM(A4:24). You can also add multiple rows or columns to your equation, like =SUM(A4:24, C2:C10)^{[5]
  X
  Trustworthy Source
  
  Microsoft Support
  Technical support and product information from Microsoft.
  
  Go to source}
6
Press ↵ 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.

Community Q&A

Search

Add New Question

Question

I need to add an entire column of cells containing formulas, not just 2. Can't make it work. How do I do this?

Darlene Antonelli

Community Answer

If you're adding a range of cells, like an entire column, enter "=SUM(A4:24)" .

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 32 Helpful 3
Question

How do you add a column of numbers (numbers derived by multiplying 2 cells) ex: cells A1 x A2, A1 x A3... all the way to A1 x A37. The total would show on A38.

Darlene Antonelli

Community Answer

If you're adding a range of cells, like an entire column, enter "=SUM(A4:24)" .

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 8 Helpful 4
Question

Hi. I'm trying to sum several cells that contain sums of other cells. I do as the example, but I get an error message saying the formula is wrong.

Darlene Antonelli

Community Answer

Add =VALUE around the formulas in the cells you're adding together. If the cells you're adding together use formulas that contain non-numeric 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] Double-click 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) )).

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 27 Helpful 4