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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average 7
#DIV/0 error 3
Excel wont display a zero when dividing 5
Average time 1
Need to average data if in cells, but ignore blank cells. 4
#DIV/0! ERROR 2
Pivot Table calculated field error 2
Divide by Zero Error in Pivot Table 2

Back
Top