Averaging a range of numbers

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

I am trying to average a range of numbers but it is not
working. The numbers are in decimal format (for instance,
0.720820512820513) and there are 10 in each range. When I
try to average it, however, Excel gives me the #DIV/0!
error. What am I doing wrong?
 
Does one of the cells in your range have a #DIV0 error in it??

If so and that is acceptable, then you can use the following:-

=AVERAGE(IF(ISERROR($A$1:$A$20),"",$A$1:$A$20))

Array entered using CTRL+SHIFT+ENTER

Personally I would prefer to fix the problem causing me to gat a #DIV0 error in
the range of data to start with.
 
If the syntax is correct and there are no errors in the range that you
are trying to average, then your cells contain text rather than numeric
numbers. You can verify this by =COUNT(range) returning zero.

copy a cell that contains zero, select the range, and Edit|Paste
Special|Add to coonvert to numeric numbers.

Jerry
 
Back
Top