How to calculate the sum of filtered cells

How to calculate the sum of filtered cells

When one wants to hide data from the view, excel has a filter option that filters data in the worksheet. This also data into the filtered and the visible. It may be easy to sum numbers in an excel column, and sometimes you may need the filter option to hide some data to meet your