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
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 202 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 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!