SUM and COUNT Visible Cells Only | Exclude Hidden Cells

Excel Training

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