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>

 

[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