How to find an average with variables
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.
Answers

You are going to need an AVG/COLLECT.
=AVG(COLLECT([Budget Margin]:[Budget Margin]; Segment:Segment; @cell = "SEED"; DK:DK; @cell > 0))
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!