# Use cell references in a formula

When you create a simple formula or a formula using a function, you can refer to data in cells by including cell references in the formula. For example, when you type or select the cell reference A2, the formula uses the value of that cell to calculate the result. You can also reference a range of cells, like A2:A6.

1. Select the cell where you want to enter the formula.

2. In the formula bar , type = (equal sign).

3. Select the cell or range of cells, or type the cell reference.

4. Press Enter.

## Example

The workbook below shows examples of using cell references. You can change values or formulas in any cells, and see the updated results. In the workbook, B2:B4 is defined as "Assets" and C2:C4 is defined as "Liabilities."

 Department Assets Liabilities IT 274000 71000 Admin 67000 18000 HR 44000 3000 Formula Description R esult '=SUM(Assets) Returns the total of the assets for the three departments in defined name "Assets," which is defined as the cell range B2:B4. (385000) =SUM(Assets) '=SUM(Assets)-SUM(Liabilities) Subtracts the sum of the defined name "Liabilities" from the sum of the defined name "Assets." (293000) =SUM(Assets)-SUM(Liabilities)
Expand your Office skills
Explore training
Get new features first
Join Office Insiders