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 ...

I've always found it frustrating that Excel's most popular functions, such as SUM, AVERAGE, MIN, and MAX, fall apart the moment your data has a single error value. A ...

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals. Learn how to ...