Help with #Divide By Zero
How do I adjust the syntax in this formula to avoid the '#Divide By Zero' error? I would like it to return a black cell for the months where this no data yet. I've tried using IFERROR in a variety of ways but that's either not the right solution or I'm not applying it correctly.
=AVG(COLLECT({Order Submission Time}, {Received By Month}, AND(@cell <= DATE(2022, 3, 31), @cell >= DATE(2022, 3, 1)), {OM Orders Received}, "Angie Blue"))
Best Answers
-
Have you tried =IFERROR(AVG(COLLECT({Order Submission Time}, {Received By Month}, AND(@cell <= DATE(2022, 3, 31), @cell >= DATE(2022, 3, 1)), {OM Orders Received}, "Angie Blue")),"")
-
@Christina Lam Yes! That worked. I was so close - didn't have "" out side the last double close parenthesis.
Answers
-
Have you tried =IFERROR(AVG(COLLECT({Order Submission Time}, {Received By Month}, AND(@cell <= DATE(2022, 3, 31), @cell >= DATE(2022, 3, 1)), {OM Orders Received}, "Angie Blue")),"")
-
@Christina Lam Yes! That worked. I was so close - didn't have "" out side the last double close parenthesis.
Help Article Resources
Categories
Check out the Formula Handbook template!