FIU Digital Project Guidelines and Help Materials

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.

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")