How to find an average with variables

Frederik Soerensen

Hello.

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.

Paul Newcome

You are going to need an AVG/COLLECT.

=AVG(COLLECT([Budget Margin]:[Budget Margin]; Segment:Segment; @cell = "SEED"; DK:DK; @cell > 0))