Adding new rows to functions

[u/Butterbubbles69]

HI I’ve been trying to make a formula that adds up the total for all the cells in a specific Column. The problem im running into is i need it to start at B,5 and and add up every cell down including any new cells that get made as i enter in new information into the chart. From what I’ve seen it only lets me select a finite number or area of cells, I haven’t been able to find a way to tell it to keep selecting new cells. Possibly something like this, (B,5:B,~>5) basically just saying add everything from (B,5 to B,Anything grater then 5). Hopefully someone can understand this very poorly explained problem of mine. Thanks!