Average Error

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

Jerry W. Lewis

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

#DIV/0 error 3
Need to average data if in cells, but ignore blank cells. 4
Average 7
Average time 1
Excel wont display a zero when dividing 5
How do I average a group of cells and ignore a #div/0! error? 8
Pivot Table calculated field error 2
#DIV/0! ERROR 2

Top