How to find an average with variables


I am trying to find the average budget margin from a specific segment and location.

I am trying to make a formula that calculates the average budget margin if the segment is "SEED" and the Location (number) is "> 0".

I tried using different variations of the following AverageIF formula:

=AVERAGEIF([Budget Margin]:[Budget Margin]; Segment:Segment = "SEED"; DK:DK = >0)

this doesn't work.

Does anyone know how I can achieve a correct formula? or is there another way to achieve the calculation?

Thank you in advance.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!