I am trying to average how many days a claim has been open for a certain technician. We signify the claim being open by having a certain column being blank... here is the current formula that I have:
=AVG(COLLECT({West (Tech Sheet) Range 1}, "", {West (Tech Sheet) Range 2}, "Artur Alimov - ARAL", {West (Tech Sheet) Range 4}))
I have been successful in using a formula to average the days assigned for claims that were assigned to a specific person:
=AVERAGEIF({West (Tech Sheet) Range 2}, "Artur Alimov - ARAL", {West (Tech Sheet) Range 4})
Any help would be much appreciated if you know of a way to use multiple criteria to average