How to Sum Two Excel Cells Containing the Result of Other Formulas

Table of contents:

How to Sum Two Excel Cells Containing the Result of Other Formulas
How to Sum Two Excel Cells Containing the Result of Other Formulas
Anonim

This article explains how to use Excel's "SUM ()" function to sum two cells that contain the result of other summations. If you get an error message when you try to add two cells, it is most likely because one of the original formulas contains additional characters or multiple functions. In this case you can solve the problem by inserting these formulas inside the Excel "VALUE ()" function.

Steps

Add Two Cells Already Containing Sum of Other Formulas Step 1
Add Two Cells Already Containing Sum of Other Formulas Step 1

Step 1. Open the worksheet you want to edit using Microsoft Excel

Step 2. Enter the formulas in the cells you want to add into the = VALUE () function

If the cells under consideration contain non-numeric values, you will need to use the = VALUE () function to be able to add without errors.

  • If the cells you want to sum contain any other formula other than the = SUM () function, you will need to convert the final result using the cell contents as the argument of the = VALUE () function. This step is necessary to avoid displaying an error message. Follow these instructions for each of the cells you want to sum:
  • Double-click the cell that contains the formula;
  • If the formula in question represents a standard mathematical formula, for example the function = SUM (A1: A15), you will not need to make any changes;
  • If the cell contains other types of functions (for example the IF () or AVERAGE () function), letters or symbols, you will have to insert the formula inside the brackets of the function = VALUE ();
  • For example, the formula = SUM (AVERAGE (A1: A15), AVERAGE (B1: B15)) should become = VALUE (SUM (AVERAGE (A1: A15), AVERAGE (B1: B15))).
Add Two Cells Already Containing Sum of Other Formulas Step 3
Add Two Cells Already Containing Sum of Other Formulas Step 3

Step 3. Click on an empty cell

This is the point on the sheet where you are going to enter the formula that will add up the other two cells.

Add Two Cells Already Containing Sum of Other Formulas Step 4
Add Two Cells Already Containing Sum of Other Formulas Step 4

Step 4. Enter the "SUM" function

Type the code = SUM () into the cell you selected.

Add Two Cells Already Containing Sum of Other Formulas Step 5
Add Two Cells Already Containing Sum of Other Formulas Step 5

Step 5. Enter the references to the cells that contain the summation values you want to add together

You must enter the addresses of the two cells (for example A4 and B4) inside the brackets of the "SUM" formula, separated by a comma.

For example, if you want to sum the contents of cells "A4" and "B4", your final formula should be as follows: = SUM (A4, B4)

Add Two Cells Already Containing Sum of Other Formulas Step 7
Add Two Cells Already Containing Sum of Other Formulas Step 7

Step 6. Press the Enter key

The values of the indicated cells will be added together and the result will be stored in the cell where you entered the "SUM" function.

  • If the value of one of the two cells in question should change, the result of the "SUM" function will also change accordingly.
  • You can update all formula results in the worksheet by pressing the F9 function key.

Recommended:

4 Ways to Shred Documents Containing Sensitive Data

4 Ways to Shred Documents Containing Sensitive Data

Each month, we happen to receive several documents containing sensitive information about us, such as bank or credit card statements, invoices and utility bills. If you work for a government institution or a multinational, you may also be dealing with information that is covered by state secrecy or confidential.

How to Print the Formulas Used in the Cells of an Excel Sheet

How to Print the Formulas Used in the Cells of an Excel Sheet

Have you ever needed to show a person an Excel spreadsheet showing some calculations and that person wants to see the formulas used to calculate those values? With this article, you will learn how to print a sheet like this on paper. Steps Step 1.

How to teach to estimate the result

How to teach to estimate the result

Being able to make an estimate is an essential skill. It is a great idea to teach children to make an estimate from an early age, so that they understand its importance as soon as possible and begin to hone their skills. Although young children struggle to grasp the concept, there are many ways to teach them to estimate through a variety of playful activities.

How to Lose Two Pounds in Two Weeks: 9 Steps

How to Lose Two Pounds in Two Weeks: 9 Steps

Losing two pounds in two weeks takes a lot of effort and patience. A weight loss is considered healthy when you lose 0.5-1 kg per week; therefore, losing two kilos in two weeks or one kilo per week is considered a somewhat ambitious goal; if you want to achieve it, you have to change your diet and add regular physical activity.

3 Ways to Make a Lip Gloss Containing Glitter

3 Ways to Make a Lip Gloss Containing Glitter

Making your own lip gloss is quick and easy. Having acquired the basics, it is possible to make it in various colors and fragrances. The simplest and fastest recipe requires just two ingredients: coconut oil and pearly cake dye. If you want to make a more elaborate lip gloss, then you will need to add some beeswax and shea butter.