Average if Formula Help

[Sparda142]

Hello.

how can i add weekday to the formula below. right now the formula im using is giving me the average interval, i need it to say per weekday per interval .

im trying to get the average for all mondays in the year at 8:30 am.

{=AVERAGE(IF(($A$2:$B$18927)=$E2,$C$2:$C$18927))}

a b c d e f g h

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Interval[/TD]
[TD]Outbound[/TD]
[TD]weekday[/TD]
[TD]interval2[/TD]
[TD]weekday (3)[/TD]
[TD]weekday (4)[/TD]
[TD]weekday (4)[/TD]
[/TR]
[TR]
[TD]1/2/2018[/TD]
[TD]8:30 AM[/TD]
[TD]57[/TD]
[TD]3[/TD]
[TD]8:30 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/2/2018[/TD]
[TD]8:45 AM[/TD]
[TD]59[/TD]
[TD]3[/TD]
[TD]8:45 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/2/2018[/TD]
[TD]9:00 AM[/TD]
[TD]109[/TD]
[TD]3[/TD]
[TD]9:00 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/2/2018[/TD]
[TD]9:15 AM[/TD]
[TD]123[/TD]
[TD]3[/TD]
[TD]9:15 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/3/2018[/TD]
[TD]8:30 AM[/TD]
[TD]95[/TD]
[TD]4[/TD]
[TD]8:30 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/3/2018[/TD]
[TD]8:45 AM[/TD]
[TD]82[/TD]
[TD]4[/TD]
[TD]8:45 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/3/2018[/TD]
[TD]9:00 AM[/TD]
[TD]51[/TD]
[TD]4[/TD]
[TD]9:00 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/3/2018[/TD]
[TD]9:15 AM[/TD]
[TD]67[/TD]
[TD]4[/TD]
[TD]9:15 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/4/2018[/TD]
[TD]8:30 AM[/TD]
[TD]51[/TD]
[TD]5[/TD]
[TD]8:30 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]weekday (2)[/TD]
[/TR]
</tbody>[/TABLE]

 

[offthelip]

you can use the AVERAGEIFS functions which allows you to add more than one conditions, so you don't need an array formula:
=AVERAGEIFS($C$3:$C$11,$B$3:$B$11,$E3,$D$3:$D$11,3)
Note the last 3 is the weekday. I would suggest you put this in a cell , and use a reference instead.

 

[Sparda142]

thanks so much!