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

Date	Interval	Outbound	weekday	interval2	weekday (3)	weekday (4)	weekday (4)
1/2/2018	8:30 AM	57	3	8:30 AM
1/2/2018	8:45 AM	59	3	8:45 AM
1/2/2018	9:00 AM	109	3	9:00 AM
1/2/2018	9:15 AM	123	3	9:15 AM
1/3/2018	8:30 AM	95	4	8:30 AM
1/3/2018	8:45 AM	82	4	8:45 AM
1/3/2018	9:00 AM	51	4	9:00 AM
1/3/2018	9:15 AM	67	4	9:15 AM
1/4/2018	8:30 AM	51	5	8:30 AM

<tbody>
</tbody>

weekday (2)

<tbody>
</tbody>

 

[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!