Average Error

  • Thread starter Thread starter Laytonius
  • Start date Start date
L

Laytonius

I am trying to average the values in two columns. This would be an average
for each row. I understand it is typical to get a #DIV/0! error if one of
the columns has a zero in it but it is giving me the #DIV/0! error even
without a zero or null value in every row.
 
Change the function from AVERAGE to COUNT. If you get 0, then your cells
contain text that only look like numbers, and hence are ignored by AVERAGE.

Jerry
 
Back
Top