Skip to main content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

FIU Digital Project Guidelines and Help Materials

The internal standard operating procedures for FIU Libraries' digital collections

Locking Formulas (for copying by dragging down)

Sometimes, when you copy a formula in a table it is helpful to have the row and column information update with each row. However, the can also cause problems if the cell range adjusts outside of the scope you want to apply the formula to.

Here is an example of an issue that can occur when you have a formula that references a set of cells in a table and you use the select an drag method of coping the formula to new cells.

Excel Lock Formulas


The solution is to use the "$" symbol to lock the column and row information in your formula so it won't shift as it is copied.

Your formula will now read:  =COUNTIF($B$2:$B$2089, "RTE, TWO")