2. If you only pull down the horizontal sum, you can only find the sum of a single line. Can't meet the demand, so we need to use a new sum function method.

3. The daily income plus the daily income minus the expenses, so that the income can be accumulated first. Enter the function formula =SUM(B$3:B3) after the balance, that is, column B3 in the third row of SUM. Drop down to see the total of all accumulations.

4. Calculate the accumulated expenditure in the same way. Enter the formula in the next column, and the first input =SUM(C$3:C3) will be pulled down to calculate the cumulative sum of expenditures.

5. Fill in the calculation formula in the balance formula, first =E3-F3. Pull it down and it will be balanced.

6. Replace E3 with the corresponding E3 cumulative income formula, replace F3 with the corresponding E3 cumulative expenditure formula, and delete the equal sign.

7. After the formula is entered, the final balance is needed, and the automatic bill is ready.