SOLVED

# Combining Average and If functions with multiple conditions

Copper Contributor

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

2 Replies

# Re: Combining Average and If functions with multiple conditions

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

best response confirmed by BP-Moons (Copper Contributor)
Solution

# Re: Combining Average and If functions with multiple conditions

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.

1 best response

Accepted Solutions
best response confirmed by BP-Moons (Copper Contributor)
Solution

# Re: Combining Average and If functions with multiple conditions

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.