Hello,
Why am i getting #DIV/0! ???
=AVERAGEIFS($C$3:$C$40929,$B$3:$B$40929,$E3,$D$3:$D$40929,F$2)
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
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>