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