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. ...
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.
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.