Finding Average Duration Time


I am trying to get an average duration for a Sheet Summary field but getting "0". My formula is as follows:

=SUMIFS([Total Onsite Time]:[Total Onsite Time], [Store Status]:[Store Status], >"" / COUNTIF([Store Status]:[Store Status], "Store Fully Open"))

What am I missing?

Thank you in advance

Sharon C



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!