Averages formula/0
Just wanted to thank you all and tell anyone else looking who is dealing with
#DIV/0 the formula below is the one that works. Be certain to press
CTRL+SHIFT+ENTER once you've entered the formula and format that cell for
percentage.
"daddylonglegs" wrote:
You could do that by using the formula
=AVERAGE(IF(ISNUMBER(B2:B6),B2:B6))
confirmed with CTRL+SHIFT+ENTER
althought it might be better to replace your #DIV/0! error with a blank,
allowing you to use just
=ABVERAGE(B2:B6)
If your formula in B2 is something like
=X3/B1
change to
=IF(B1,X3/B1,"")
"rldjda" wrote:
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?
|