i tried to average cells that include one or more errors in google spreadsheet, seems =average(D:D) is not working. how to avoid those errors? Thanks!

CodePudding user response：

You may try AVERAGEIF() function like-

=AVERAGEIF(D:D,">0")

Above formula will ignore error values.

CodePudding user response：

try this:

=AVERAGE(IFERROR(D:D))