Video instructions and help with filling out and completing Can 8850 Form Totaling

Instructions and Help about Can 8850 Form Totaling

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 to keep Row two as the starting point so I'm going to click in front of the two and type a dollar sign so this row reference is absolute it won't change as we copy the formula down I'm going to press ENTER again click on this cell and double click in the fill handle at the corner and that copies it down again this time we can see the total here the current total is the same as our total for that whole column so we know it's correct now if we look at this formula it's always starting at c2 and then going down to the current row so this is in row six it's adding up everything to row six in row four it goes from two to four so we create a running total by making the starting row absolute and we keep a relative reference for the endpoint so that will change as you copy it down for more excel tips and tutorials please visit my contexture website at wwlp.com