Can 8850 Form Totaling 2016-2023

On this worksheet we have a list of bank transactions starting with the opening balance and then withdrawals and deposits after that I'd like to see the current total and I can do that by using the sum function in this cell start with an equal sign and then S um Open bracket I'll click on the button at the top of column C and that puts the whole column into the formula close the bracket and press Enter so there's currently a hundred and ten dollars in column C based on the opening balance and then subtracting for withdrawals and adding the deposits we could also show a running total as we go along so in this cell d2 I could see what we've accumulated to date and then copy that formula down so it will show the total at each row in this cell I'll start with an equal sign and again it's the sum function and an Open bracket and in this cell we want to get from C to and then a colon we want to end at c2 as well I'm going to close the bracket and press Enter so here we can see that the total from c2 to c2 is a hundred now I want to copy this down and we'll see what happens in its current state when we copy down so a double click on that button in the corner that fills it down we can see that in each row it's just adding that row here at saying c6 to c6 but what we really want is c2 to c6 so I'm going to change this formula so instead of changing everything as it moves down these rows I want it to change the end position but I want it...