Average turnaround time based on 2 columns

Natalia Pagano

Hi,

I'm trying to calculate the average turnaround time based on the level of priority column and the average days calculated in Avg turnaround by COO.

I've tried the AVERAGEIF Function can't seem to find the right combination. Could someone help in giving me a string that for example, if it's medium priority it calculates the average turnaround for that priority?

Thanks!

Paul Newcome

Try this one...

=AVG(COLLECT([Average Turnaround Time For COO Review]:[Average Turn Around Time For COO Review], [Level of Priority]:[Level of Priority], "Medium"))

Paul Newcome

Try this one...

=AVG(COLLECT([Average Turnaround Time For COO Review]:[Average Turn Around Time For COO Review], [Level of Priority]:[Level of Priority], "Medium"))

Natalia Pagano

@Paul Newcome Hi Paul! I'm looking to calculate the average turnaround based on a date. So looking to recalculate for 2022 the formula above is perfect just need it for specific dates. Any formula modification for that?

Paul Newcome

@Natalia Pagano Do you mean for any entries where the date is in the year 2022?

=AVG(COLLECT([Average Turnaround Time For COO Review]:[Average Turn Around Time For COO Review], [Level of Priority]:[Level of Priority], "Medium", [Date Column]:[Date Column], IFERROR(YEAR(@cell), 0) = 2022))