Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/06/SUM-and-COUNT-Filtered-Records.xlsx

In this video I demonstrate how to sum and count filtered data. If you want to exclude hidden cells from your calculations you can use either the SUBTOTAL or AGGREGATE functions. Both these functions allow you to perform SUM and COUNT calculations as well as many others.

The other option is to house your data in an Excel table. Excel tables include the option to display a total row. Every cell in the total row includes a drop-down list of calculations including SUM and COUNT. These calculations use the SUBTOTAL function.
------------------------