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)