Averages formula/0
Try this:
Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):
=AVERAGE(IF(ISNUMBER(B2:B6),B2:B6))
Format as %
You'd be better off fixing the errors so that those formulas return a blank
("") rather than the #DIV/0! error. Then a simple =AVERAGE(B2:B6) will work.
Biff
"rldjda" wrote in message
...
I have an entire column with #DIV/0! because it is awaiting data from
adjacent cells. The sum of the formulas result in a %.
Example:
B2 10%
B3 15%
B4 #DIV/0!
B5 #DIV/0!
B6 25%
QUESTION: How can I get the % average of B2:B6?
|