I'm trying to write a formula that finds the average from a table with 3 sets of criteria:
Agent = X
Activity = Y
Day = Z
Average duration for those conditions.
I've got the formula but 1 part of it requires an additional column (F) that converts the activity start date/time into the day of the month.
View attachment 94846
I've tried using DAY() on the Activity Start Date/Time column to eliminate the need for the extra conversion column, but just get an error.
Any help gratefully received.
Agent = X
Activity = Y
Day = Z
Average duration for those conditions.
I've got the formula but 1 part of it requires an additional column (F) that converts the activity start date/time into the day of the month.
View attachment 94846
I've tried using DAY() on the Activity Start Date/Time column to eliminate the need for the extra conversion column, but just get an error.
Any help gratefully received.