Average of Boxes Checked in Column

Lisa Marie
Lisa Marie ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello all!

I have a column of check boxes in which I'm trying to find the average number of boxes checked in a range.

I'm trying to use the COLLECT function, w/this formula:

=AVG(COLLECT([Photography Needed]2:[Photography Needed]5, [Photography Needed]2:[Photography Needed]5, 1))

When I do so, I receive the error =DIVIDE BY ZERO.

Can anyone shed some light on what I'm doing wrong?

Thanks in advance!





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!