Other benefits to using SUBTOTAL are that you can opt to ignore any numbers that have been hidden, dynamically summarize data, and sum filtered values. And one of the most useful reasons is that you ...

Learn how to create interactive dashboards and dynamic workflows in Excel using modern functions like SUBTOTAL, AGGREGATE, and SWITCH.

In Excel 2003, choose Subtotals from the Data menu. This time, select Sum from the Function dropdown. Uncheck the Unit Price and Units In Stock in the Add Subtotal To list and check Units In Stock.

Click the Data tab. Click Subtotal in the Outline group. In Excel 2003, Subtotals is on the Data menu. In the resulting dialog, choose Count from the Function dropdown.

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

Note: When SUBTOTAL () function is used on filtered data, hidden values are always ignored regardless of the function_num argument. So this is how you can count colored cells in Microsoft Excel.