AverageIf Function


I'm sure there is a very easy solution to this one, but need some help...

I want to capture the average of Range 29 IF Range 36 is marked as complete. I also enveloped this in the "Collect" function and the "If Error" function, but still no luck.

=AVERAGEIF({Range 29}, {Range 36}, "Complete")

I am receiving the "#INCORRECT ARGUMENT SET" error.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!