ðŸ‘‰

### Did you like how we did? Rate your experience!

Rated 4.5 out of 5 stars by our customers 561

## 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. It starts with the opening balance, followed by withdrawals and deposits. To see the current total, we can use the sum function. In the cell, start with an equal sign and then "SUM(". Click on the button at the top of column C to include the entire column in the formula. Close the bracket and press Enter. Currently, there is a hundred and ten dollars in column C, based on the opening balance, withdrawals, and deposits. To show a running total, we can use the formula in cell D2. Copy the formula down to show the total at each row. In the cell, start with an equal sign and again use the sum function. Use "C2:C2" to get the total from C2 to C2. Close the bracket and press Enter. The total from C2 to C2 is a hundred. When we copy the formula down in its current state, it only adds the current row. However, we want it to add from C2 to the current row. To change this, we need to make some adjustments to the formula. Instead of changing everything as it moves down the rows, we want to change the end position but keep Row 2 as the starting point. To do this, click in front of the two and type a dollar sign, making the row reference absolute. Press Enter. Click on the cell again and double click in the fill handle at the corner to copy it down. Now the total correctly shows the total from C2 to the current row. The formula always starts at C2 and goes down to the current row. This creates a running total. The starting row remains absolute, while the endpoint changes as you copy it down. For...