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
Using the "Average" function
Using the "Average" function
- Attachments
-
- PROFIT.jpg (12.43 KiB) Viewed 6642 times
- jimjutte
- SoftMaker Volunteers
- Posts: 638
- Joined: Sun Oct 28, 2007 9:08 pm
- Location: Chatham, Ontario, Canada
- Contact:
Re: Using the "Average" function
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.
I'll see if there is another way, but for now, you may be stuck with click,shift-click. Sorry.
Cheers
Jim
Jim
Re: Using the "Average" function
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.
Sven Leßmann
SoftMaker Software GmbH
SoftMaker Software GmbH
Re: Using the "Average" function
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.