Need help applying AvgIf and/or AvgCollect

Jennifer1

I am trying to find the average of a column with specific criteria. I have avg TAT and I am trying to find the average when the Run Type is specific.

Jennifer1

Current formula I am trying: =AVG(COLLECT(TAT:TAT, [Run Type]:[Run Type], OR(@cell = "A", @cell = "B")))

It isn't pulling the average correctly.

Paul Newcome

Your formula is going to grab all rows where the Run Type column is either "A" or "B". Based on the screenshot, that means it is going to pull in all 3 numbers and average them (23).

Is it not supposed to pull in both letters?