Combining Average and If functions with multiple conditions

[BP-Moons]

As shown in the screen shot attached. I am trying to write a formula that will calculate the average of stops per hour for all rows that contain D01:D05 but only the values from 20/05/2024. 

Is this possible ? hoping to automate the calculations as much as possible to save time. 

[#2]

@BP-Moons 

Hi, please see attached book with proposed solution. Does this work?

=AVERAGE(CHOOSECOLS(FILTER(Table1,(Table1[Date]=J2)*(ISNUMBER(MATCH(Table1[Loom],H2:H7,0)))),6))

Martin

[#3 · Accepted solution]

@BP-Moons 

Depends on which Excel you are. As variant that could be something like

=AVERAGE( AVERAGEIFS( Table[Stop/Hour], Table[Loom No], $H$2:$H$7, Table[Date], $J3) )

with Ctrl+Shift+Enter on old versions.