Rain Fall Average

Robert S Fike
Robert S Fike ✭✭✭✭
edited 09/22/23 in Formulas and Functions

Trying to average rainfall from a seperate sheet. Each row has a Neighborhood, Daily Rainfall and Month #. I get an error #Divide by zero.

=AVG(COLLECT({LNH Rainfall Daily Total}, {LNH Rainfall Neighborhood}, Neighborhood@row, {LNH Rainfall Month #}, Jan6))

Any thoughts?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!