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

Options
JayneB
JayneB
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.

E.g.

Any help would be greatly appreciated

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!