This is the demonstration file to accompany the article, How to calculate conditional subtotals in an Excel revenue sheet, by Susan Harkins.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.