Averages formula/0
=SUM(B2:B6)/(COUNTA(B2:B6)-COUNTBLANKS(B2:B6))
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"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?
|