A cell reference is simply a way of identifying a specific cell in your spreadsheet.

For example, if the particular unit cost of a product sold was $1.10 per unit and that cost never changes, you would use an absolute reference pointing back to that cell any time you enter a ...

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

Open a New Worksheet; Launch Excel and create a new worksheet named "June." Type "Sales" in cell A1 and "1000" in cell B1. Do not place parentheses around these values.

Similar to other functions, COUNTIF() can reference cells or ranges. However, the condition is altogether another thing. If the condition is in a cell, you’re fine, but that often won’t be the ...