Contract Tracking Table

An Excel file that teaches how to perform Contract Tracking Table operation.

Excel Spreadsheet for Contract Tracking Table

Cumulative totals are tracked by row. The first negative result is captured by a conditional formula. The DATE and ROW functions are used together. Error conditions are handled gracefully. Ranges are dynamically expanded. The result is reported in a single cell.

Hope it is useful.