AVERAGEIF COLLECT with multiple criteria from multiple columns



What is the best formula to use to incorporate a second column criteria to an AVERAGEIF formula? I tried to use COLLECT in the formula but it's giving me an incorrect argument error.

I tried this but it's giving error.

=ROUND(AVERAGEIF([Site Rec'd:]:[Site Rec'd:], "F05", [Spec Type:]:[Spec Type:], "MS", [Receipt to Test/Spl Plan TAT]:[Receipt to Test/Spl Plan TAT]))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!