How to average filtered cells/list in Excel?
Average function is quite useful for our daily works in Excel. This article will talk about how to average filtered data/list in Excel easily.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
If the AVERAGE function is applied in the filtered data or list, it will not get the correct average. In this condition, the SUBTOTAL function can help you average filtered data/list in Excel. Supposing you have filtered your table as following screen shots shown, you can get its average as follows:
In a blank cell enter the formula =SUBTOTAL(1,C12:C24) (C12:C24 is the range with all filtered data in Amount column) and press the Enter key.