How to calculate conditional subtotals in an Excel revenue sheet

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.