Other ways to enter cell references
Imagine that you want to know the combined cost for video rentals and CDs in February.
Click cell C6. That cell reference appears in cell C9 following the comma. Type a closing parenthesis after it.
The example shows you how to enter a formula into cell C9 by clicking cells.
Press ENTER to display the formula result, 45.94.
A color marquee surrounds each cell as it is selected and disappears when you press ENTER to display the result.