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

Please see the yellow banner at top of the page on how to attach a sample workbook: be sure to add manually-calculated results.

CV Feedback ? Which column
Average time to fill ? Which column

At least the name must be consistent, otherwise the corresponding or cannot be found


Cell C3 formula , Drag down

Formula:

=AVERAGE(IF(('Raw data'!$D$2:$D$21=B$2)*ISNUMBER('Raw data'!$E$2:$O$21)*ISNUMBER(SEARCH('Raw data'!$E$1:$O$1,B3)),'Raw data'!$E$2:$O$21))

Cell C9 formula , Drag down

Formula:

=AVERAGE(IF(('Raw data'!$B$2:$B$21=1050)*ISNUMBER('Raw data'!$E$2:$O$21)*ISNUMBER(SEARCH('Raw data'!$E$1:$O$1,B9)),'Raw data'!$E$2:$O$21))

Cell C15 formula , Drag down

Formula:

=AVERAGE(IF((MMULT(N('Raw data'!$B$2:$B$21={1050,1030,1020}),{1;1;1}))*ISNUMBER('Raw data'!$E$2:$O$21)*ISNUMBER(SEARCH('Raw data'!$E$1:$O$1,B15)),'Raw data'!$E$2:$O$21))