Forum Discussion
Solved
Combining Average and If functions with multiple conditions
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.
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.
2 Replies
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.
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
