SUM and COUNT Visible Cells Only | Exclude Hidden Cells

Microsoft Excel Tips and Tricks

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.

Credit Chester Tugwell