Getting Average from a filtered column

[gheyman]

I have two columns

One has Part Numbers (There are Duplicates)
Second has Unit Prices

I want to see the Average Unit Price when I filter. I cant use countif/SumIf.... I want to be able to filter on both columns so doing CountIf/SumIf by part number doesn't help me in this situation. I am hoping there is a formula that will give me an average for the second column based on whats filtered.

Thanks

 

[Fluff]

Have a look at the SUBTOTAL function.

 

[Yongle]

or
if data is in a structured Excel table ...

- turn on Total Row
- select "average" as the total for that column
- calculated average is based on filtered rows