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.

How to add a condition to rank using a PivotTable in Excel A simple rank is easy to calculate, but sometimes you’ll want to accommodate a condition.