Arrary Formula for Average If/Or

Good morning,

I'm trying to create a formula that will average certain items that meet the following criteria:
1) if column C matches F$1 on the Markup tab
2) and if column A matches either of the following: $D58 on the Markup tab OR $E58

After that, I need the average of the associated figures in column J.

It returns a number... but it's not the right number (and yes, I did Cntl + Shift + Enter and it added the brackets)

I think the problem is that it is acknowledging blanks as 0's... how do I have it skip blanks?

=AVERAGE(IF(('Source-Detail'!$C$1:$C$2000=Markup!F$1)*(('Source-Detail'!$A$1:$A$2000=Markup!$D58)+('Source-Detail'!$A$1:$A$2000=Markup!$E58)),'Source-Detail'!$J$1:$J$2000))

Hi Nigelbloomy,

Unfortunately not it gives a VALUE error.