How to calculate the average without taking zeros values?

Hi, I have a large data list which has this form:


I need to calculate the average of multiple cells and I want to exclude values = 0.


b *** c *** d
a 2011/5/8 *** 158
a 2010/5/8 *** 142
a 2014/5/8 *** 121
w 2013/5/8 *** 180
w 2015/5/8 *** 187
d 2010/4/8 *** 145
f 2009/5/8 *** 458
a 2008/5/8 *** 149
d 2006/5/8 *** 129
f 2005/5/8 *** 143



=AVERAGEIF(INDEX((B2:B1248=e1)*(D2:D1248);">0")====>>>#VALUE!