Avg of a range with 2 criteria


I am trying to average a range (which are percentages) based on the Issue Date Year and the Type.

I have tried:

=AVG(COLLECT({Row Averages}, {QA Type}, "Internal", {QA Initial Date}, Year=2020))


=AVERAGEIF({QA Type}:{QA Type}, "Internal", {QA Initial Date}:{QA Initial Date}, Year=2020, {Row Averages}:{Row Averages})

and any combo you can think of :) .. still can't get it to return nicely.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!