Be sure to copy this formula down the column so additional shifts on other rows will calculate, as well. Click the bottom line of a cell and drag it down the column to copy it.