Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

You can subtract multiple cells from one cell in Excel by using Minus sign, SUM function and Paste Special feature. Here is a tutorial on this.

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.