I was able to change my cell range to a 'Table', you know where it automatically highlights the rows alternating colors of blue - adding a new line automatically propagates any formulas from the line above!