Divide by Zero Error


I'm deep over my head in a couple formulas. In the screen grab below you'll see Location and the various formulas that follow:

Count based on sheet: =COUNTIF({ERG MEMBERSHIP EA Location}, @cell = "REMOTE")

Previous Month - count based on sheet: =COUNTIFS({Joined Date}, IFERROR(AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()) - 1, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())), AND(IFERROR(MONTH(@cell), 0) = 12, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1)), {ERG MEMBERSHIP EA Location}, [Column2]@row)

Current Month - Count based on Sheet: =COUNTIFS({Joined Date}, AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())), {ERG MEMBERSHIP EA Location}, [Column2]@row)

MoM% Growth: =SUM(([Column5]74 - [Column4]74) / [Column4]74)

My challenge is that I receive an error in the month by month when previous month and current month are 0. Is there a way to signify 'no growth', when both a previous month and current month are 0? Thank you!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!