Excel’s Subtotal feature can render quick results when you need simple grouping calculations. Susan Harkins shows you how this powerful feature works. Excel’s Subtotal feature calculates subtotals and ...

For many years, I used the SUBTOTAL function in Microsoft Excel to create easily visible subtotals at the top of my worksheets. However, when I encountered AGGREGATE, this became my go-to function for ...

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. Subtotals are common in a lot of Excel ...