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]

 

[gaz_chops]

Appears to be a Duplicate Post

 

[Fluff]

What is in F2?
Also in you post all of col D is 3, so there is nothing to average

 

[Sparda142]

I used the following formula "=MINUTE(A3)*60+SECOND(A3)" to get the value of 00:00:32 into seconds to try and make the formula work. Then applied the "=AVERAGEIFS($C$3:$C$40929,$B$3:$B$40929,$E3,$D$3:$D$40929,F$2)" to receive the average however got the error #DIV/0!

Example : 00:00:32 = 32

 

[Fluff]

Care to answer my question?

 

[Sparda142]

F2 is "2" for week day

In col D i have the cell range of "$D$3:$D$40929"

The excel file can be found here.
https://www.mediafire.com/file/86mple8knspcz5k/Book4.xlsx/file

 

[Sparda142]

F2 is "2" for week day

In col D i have the cell range of "$D$3:$D$40929"

The excel file can be found here.
https://www.mediafire.com/file/86mpl...ook4.xlsx/file

 

[Fluff]

In an empty cell enter
=B3=E3
What does it say?
Also try
=D3=G2
What does that say.
I have not downloaded your file, as I don't trust that site.

 

[Sparda142]

what site do you trust , i can upload the file there

 

[Sparda142]

=B3=E3 - False
=D3=G2 - True