When using AVG formula, is there a way to have blank entries in the columns without getting a #divid

Rachel Cox

When using AVG formula, is there a way to have blank entries in the columns without getting a #divideby error?

Jeff Reisman

https://community.smartsheet.com/discussion/comment/321366#Comment_321366

OK so in your situation, there are no populated values at all! Got it. In that case, you just want to add IFERROR to your formula, to specify a replacement value in case of an error:

=IFERROR(AVG([02/15/22]@row, [02/28/22]@row), "")

This says, if the formula results in an error, just leave the cell blank (that's the empty pair of quotes at the end.) You could also specify a value, another formula, or some other message (such as "Hey, help a poor formula out, would ya? Give me some values to average!")

Here I added another formula as the IFERROR value:

Here I added a more meaningful error message:

Jeff Reisman

@Rachel Cox

What formula are you using for AVG? When I use it, it ignores blank cells.

Blanks included in my range:

Rachel Cox

=AVG([02/15/22]@row, [02/28/22]@row)

Jeff Reisman

https://community.smartsheet.com/discussion/comment/321366#Comment_321366

OK so in your situation, there are no populated values at all! Got it. In that case, you just want to add IFERROR to your formula, to specify a replacement value in case of an error:

=IFERROR(AVG([02/15/22]@row, [02/28/22]@row), "")

This says, if the formula results in an error, just leave the cell blank (that's the empty pair of quotes at the end.) You could also specify a value, another formula, or some other message (such as "Hey, help a poor formula out, would ya? Give me some values to average!")

Here I added another formula as the IFERROR value:

Here I added a more meaningful error message:

Rachel Cox

This helped! Thank you!