AVERAGE/IF Formula issue

Good afternoon,

I am having difficulty with a formula I need. I need to do the formula to work out the average if a column has several different names/codes.

I need to know the average review and hire times for all of the jobs which have a 1020, 1030 & 1050 cost code together.

This is what I have so far.

=AVERAGEIF('Raw data'!B:B,"1050",'Raw data'!H:H)

I also need this formula to ignore any blank cells as they are giving me the DIV error.

Thank you