Q&A for How to Add Two Cells Containing the Sum of Other Formulas in Excel

Return to Full Article

Coming soon

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?

wikiHow Staff Editor
Staff Answer
This answer was written by one of our trained team of researchers who validated it for accuracy and comprehensiveness.

wikiHow Staff Editor

Staff 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 26 Helpful 2
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.

wikiHow Staff Editor
Staff Answer
This answer was written by one of our trained team of researchers who validated it for accuracy and comprehensiveness.

wikiHow Staff Editor

Staff 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 6 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.

wikiHow Staff Editor
Staff Answer
This answer was written by one of our trained team of researchers who validated it for accuracy and comprehensiveness.

wikiHow Staff Editor

Staff 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 20 Helpful 4
Question

HOW CAN I ADD COLUMNS THAT ARE NOT NEXT TO EACH OTHER?

wikiHow Staff Editor
Staff Answer
This answer was written by one of our trained team of researchers who validated it for accuracy and comprehensiveness.

wikiHow Staff Editor

Staff Answer

You can also add multiple rows or columns to your equation, like "=SUM(A4:24, C2:C10)"

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 0