I am trying to add a metric on a sheet summary for campaign tracking that pulls from two options on a column dropdown. Option A is campaigns that are “In Development” and the other is “In-Market”. I want to get the average in another column that is “duration” of days for campaigns that are “In Development” and not “In Market”.
So, think the formula would start with “COUNTIF” and that would ID the two options In Development or In-Market and point to the In Development. Then I want to average just those days and when I add the AVG command, do I start the second half of the formula with “and” or how would I add that?
First attempt was -> =COUNTIF([Campaign Status]:[Campaign Status], = “In Development”)…. That’s where I am stuck. How do I add the second command for AVG? Or is there a better formula with simply AVG that will let me only average campaigns in development?
Appreciate your consideration in advance.
Best - Scott
Help Article Resources
Check out the Formula Handbook template!