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)

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

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[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