Function AVERAGE CHILDREN excluding some "childen"

05/25/20
Accepted

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%"?


Thanks,



Best Answers

Sign In or Register to comment.