need help getting rind of #DIV/0 erron on work book

[superchew]

I have a work book that has an average if formula to calculate the average scores of audits completed in a week. problem is if an audit is not turned in on a week i get the #div/o error. I have attached a worsheet. please look in to secton c on the new accumulations tab...

Audit Tracking.xlsx

[humdingaling]

any specific reason why the array is from row 1052 to 2400?
Audit Scores'!$C$1052:$C$2400

[samba_ravi]

use iferror formula
=IFERROR(AVERAGEIFS('Audit Scores'!$D$1052:'Audit Scores'!$D$2400,'Audit Scores'!$C$1052:$C$2400,"A",'Audit Scores'!$A$1052:$A$2400,1),"")

and why can't use dynamic formula for support
instead of "A", use cell reference "U$2 and for "1" rows(V$3:V3)
if you make these above changes in your formula you can copy the formula towards the down as well as towards the left

[samba_ravi]

use iferror formula
=IFERROR(AVERAGEIFS('Audit Scores'!$D$1052:'Audit Scores'!$D$2400,'Audit Scores'!$C$1052:$C$2400,"A",Audit Scores'!$A$1052:$A$2400,1),"")

and why can't use dynamic formula for support
instead of "A", use cell reference "U$2 and for "1" rows(V$3:V3)
if you make these above changes in your formula you can copy thleftmula towards the down as well as towards the right or left

[FDibbins]

Try this, copied down. It also eliminates the need to manually adjust the number at the end....

=IFERROR(AVERAGEIFS('Audit Scores'!$D$1052:'Audit Scores'!$D$2400,'Audit Scores'!$C$1052:$C$2400,"C",'Audit Scores'!$A$1052:$A$2400,ROW()-2),0)

[superchew]

yes becuase i attend on using that many over the next couple months.

[humdingaling]

or better than using using row, use the value in column T (which is week number)

=IFERROR(AVERAGEIFS('Audit Scores'!$D$1052:$D$2400,'Audit Scores'!$C$1052:$C$2400,U$2,'Audit Scores'!$A$1052:$A$2400,$T3),0)