How to eliminate the OFFSET funtion from excel equations

Originally Posted by nflsales

Hi, bebo021999, if the data in rows increased (when updating data) your formula in F9 (Column F) will not update automatically.

Correct! Maybe use D9:$D$42 instead of D9:$D$41.