Working with filtered Data?

How to ignore hidden values of a filtered data while computing Sum, Average in Excel in Hindi

For quick filtering, do this:

1. Click the arrow Filter drop-down arrow in the table header of the column you want to filter.

2. In the list of text or numbers, uncheck the (Select All) box at the top of the list, and then check the boxes of the items you want to show in your table.