Hello everyone, this is my first post to this forum, so I apologize if this question has been addressed elsewhere. Here's the situation that I'm trying to resolve: I have several columns of production data that I'm working with. I have columns of data for operator name, type of work, total number of work units processed, and average processing time. I'm trying to have Excel calculate the average processing time for the entire department for each type of work, and was able to accomplish this using an AVERAGEIFS function that averages only numbers linked to a given type of work.

However, I'm noticing that my results are coming out skewed a bit due to various outliers present in the source data. I've decided that, in order to fix this, I want the department average to include an operator's processing time only if the operator processed at least 6 units of work of that type. This is where I'm running into a problem. Currently my formula looks like this:

=IFERROR(AVERAGEIFS(TransData!$I$2:$I$30000,TransData!$E$2:$E$30000,$A33,TransData!$F$2:$F$30000,">5"),"-")

Cell A33 is the name of the type of work that I want an average for.
Column I = average processing times
Column E = type of work
Column F = total units of work processed
Column C = operator name

So right now, the formula checks column F and only returns results if there are more than 5 documents processed. This is fine, but the problem is that the source data is also broken down by day, and there are multiple days of data present. So, operator A might have a "3" in column F on day 1, and a "4" in column F on day 2. Since the total units of work that the operator processed is greater than 5, I want it to be included in the average, but it won't be currently since each individual number is less than 5. Any thoughts on how I can modify the formula to include all data for the same operator/type of work which adds up to more than 5?

Thanks in advance to everyone for your help. If any additional info/explanation is required, please let me know.