How do you create an "AverageIf" formula for more than 1 criteria in the same column?

edited 08/18/22 in Formulas and Functions

Hi Team,

I am using a formula calculation sheet to try to work out how to create a formula to average %s in a Smartsheet where the Line of Business Column (in some cases) has more than 1 Business unit e.g. Sales and Sales (Local Sales).

I have tried Average If functions, AvgCollect, AverageAnd, but have had no luck. I just want the average of the 2 averages below, but would love it in one formula based on the master Smartsheet to make sure its accurate.


Any help would be greatly appreciated



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!