Divide by Zero Error

Monica Gallegos

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!

Jeff Hoelzel

=IFERROR(([Column5]74 - [Column4]74) / [Column4]74,"No Growth")

Kelly Drake

This might solve.....

=IFERROR(SUM([Column5]@row - [Column4]@row) / [Column4]@row), 0)

Also note the @row edit to help make the formula more efficient... https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

Jeff Hoelzel

=IFERROR(([Column5]74 - [Column4]74) / [Column4]74,"No Growth")

Kelly Drake

This might solve.....

=IFERROR(SUM([Column5]@row - [Column4]@row) / [Column4]@row), 0)

Also note the @row edit to help make the formula more efficient... https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

Monica Gallegos

Thank you both! these are very helpful!