Using the "Average" function

[fargoone]

I have a long column of figures in Planmaker 2018 that looks like this:

#DIV/0!
#DIV/0!
34.8%
61.5%
#DIV/0!
#DIV/0!
#DIV/0! Another view of the column is below.

I wish to average only the numerical ones. Not the #DIV/0!.

Is there some way to do this? This is the formula that I am using and it does not work.

=AVERAGE(K8:K323)

Thanks in advance for your help.

Chuck

[jimjutte]

Good question. I thought I might be able to solve this with an If Then statement, but it seems to keep sending back the error.

I'll see if there is another way, but for now, you may be stuck with click,shift-click. Sorry.

[sven-l]

You have to make sure that only references to cells with valid (numerical) values are inside the formula. It does not work if there are #DIV/0! cells inside the calculation.

[Jossi]

Divisions by zero (#DIV/0!) shouldn't occur at all. The correct way is to adjust your formulas to prevent this. Subsequent formulas will work then, too.