Be sure to copy this formula down the column so additional shifts on other rows will calculate, as well. Click the bottom line of a cell and drag it down the column to copy it.

The article How to calculate conditional subtotals in an Excel revenue sheet uses simple expressions, a function, and a conditional format to display a daily balance in a revenue sheet.

While copying from one spreadsheet to another, if you get Excel ran out of resources while attempting to calculate one or more formulas error, this guide will help you fix the issue.