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

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

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

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) )).

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