Average if Error

[Sparda142]

Hello,

Why am i getting #DIV/0! ???

=AVERAGEIFS($C$3:$C$40929,$B$3:$B$40929,$E3,$D$3:$D$40929,F$2)

[TABLE="width: 975"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Monday[/TD]
[TD]Tuesday[/TD]
[TD]Wednesday[/TD]
[TD]Thursday[/TD]
[TD]Friday[/TD]
[TD]Saturday[/TD]
[TD]Sunday[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Date[/TD]
[TD]Interval[/TD]
[TD]AHT in Seconds[/TD]
[TD]Weekday[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]9:00 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]10:00 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]151[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]11:00 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]565[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]12:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]7:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]114[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]9:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]141[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]10:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]11:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]116[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]509[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]24[/TD]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

In that case these values in B3 & E3 are not the same.
Set the format to Number & expand the number of decimals displayed to about 15 & you will probably find that they are slightly different.

 

[Sparda142]

Thanks, this really help! i have it working now!

 

[Fluff]

Glad you sorted it & thanks for the feedback