Divide by zero error

[rutica]

Hi,

I am using Excel 2010. I have an array that calculates an average based on certain criteria. Everything works fine except I get #DIV/0! if there is no data.

My array is:

{=AVERAGE(IF(ALL!B:B=B1,
IF(ALL!D:D=B4,
IF(ALL!E:E=C4,
IF(DATE(YEAR(ALL!F:F),MONTH(ALL!F:F),1)=D3,
ALL!H:H)))))}

Please see attached example. There are 2 tabs. The raw data is on the ALL tab. The array formulas with the errors are on the "Compliance" tab, row 4. (I have only filled in row 4 so far, but eventually I will populate the other 7 rows with formulas).

Help!
Also, I noticed the spreadsheet has gotten very slow. I suppose this is due to the array, but is there any way to fix that?

Thanks!