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

"Laytonius" wrote:

> 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.