2 Excel formulas

Job ID: 33298403

Budget: $10 – $30 USD

I am looking for two formulas.
1) After filtering for columns, I want to get the average for the results excluding zeros.
2) After filtering for columns, I want to get the median for the results excluding zeros.
Please see attachment for details.
Related categories: Excel Statistics Mathematics