Average value by month

Hi Team,

I have a scenario wherein I am trying to pull the AVG score by month wherein few cells for each of those months would be blank. I have tried AVERAGEIF with <>0 and AVG(Collect( ... but i keep getting invalid or other error types.

Can you help.



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!