# How to add an amount to multiple cells in Excel

Excel is a spreadsheet with a lot of power. The software can be used to track inventory, track and calculate payroll and a myriad of other calculations. An Excel formula is genera

Excel is a spreadsheet with a lot of power. The software can be used to track inventory, track and calculate payroll and a myriad of other calculations. An Excel formula is generally composed of several items. Knowing how to calculate formulas in Excel will make tracking various parts of your business that much easier.

## Excel Formula Breakdown

**Function** - This is the desired result. For example, SUM is the function used when you want to add values together.

**Cell References** - These are the cells that hold the values that are used to complete the function. Example A2, D5, F8, etc.

**Arithmetic Operator** - This is the operator used to calculate the function. The plus (+), minus (-), multiplication (*) and division (/) symbols are the arithmetic operators.

**Constant** - the value to which the arithmetic operator is applied. If you are calculating gross pay, the hourly rate is the constant.

## Adding Values in Excel

On of the most common uses of Excel is to calculate values. For example, if you're keeping track of inventory of your office supplies, you add up the total amount of each item by adding the cells together. If Computer Paper takes up Cells C4, C5 and C6, and the total cell is C10, you can add up the values in those cells Use the "=+" formula in the C10 cell. The formula in the C10 cell would look like this:

**=+C4+C5+C6**

Alternatively, since the cells are consecutive, you could also use the SUM feature to sum multiple columns in Excel, based on criteria. In this instance, you would place the cursor in the C10 cell, then click the SUM key on the Excel toolbar on the formula tab. Then you highlight and drag through keys C4 through C6 and hit Enter. The formula in C10 looks like this:

**(SUM=C4:C6).**

## Calculating Nonadjacent Values in Excel

Even if you have values that are not in an adjacent cell, you can still calculate them. In many cases, there will be values in different parts of a worksheet that have to be calculated together to get the desired results. For example, if you need to use the total number of hours that an employee worked and multiply it by an hourly wage to determine the gross salary, this can be completed, even if the values aren't side by side. So if the **Hours Worked** value is in D10 and the **Hourly Rate** is located in B2, and you want to calculate **Gross Pay** in F7, the formula you would write in F7 would be =D10*B2.

## Examples of Other Calculated Values

Excel has a host of precreated formulas that you can use to complete calculations. These formulas are found on the formula tab on the worksheet. You choose the formula you want to use from the drop-down menu and fill in the cell address for the values you want to use in the formula.

**Averages -** If you want to know the average of a list of numbers, the formula is **=AVERAGE(C4:C6)** (using the cells from a previous example. This formula will add the values in C4, C5 and C6 and divide that sum by 3. If there were 15 numbers in the selected area (say C1 through C15) the formula would change to **AVERAGE(C1:C15)** and the divider would be 15.