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!

image.png


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!