Function AVERAGE CHILDREN excluding some "childen"

I have a problem with formula "Average Children". In my example below, when there is no cost so % is 0%, it's included in the average of children but should not. In this case, on the third row "3%" should be 23% and in the first row "1%" should be 23%. Is it possible in a formula to say "Average children except if children is 0%"?


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!