# DIV/0 error when referencing data from web in separate cell

1. ## DIV/0 error when referencing data from web in separate cell

This may be a simple problem, but I can't find anything on the internet pertaining to my situation. On my excel sheet, I am using a website that takes recent auction prices of a product. My goal is to take the average price of them to spit out an estimated value of the product. On the cell I have selected in the photo, I am trying to use the AVERAGE function between a random set of numbers from the chart. It seems to completely disregard them as numbers and think they are all equal to zero, hints why it shows the error #DIV/0. This is driving me crazy because this is the last obstacle I have after working on this document for over a month.

2. ## Re: DIV/0 error when referencing data from web in separate cell

Those values have dollar signs in them so I suspect the cells are Text values, rather than being formatted numbers. I'd do a global replace of \$ for nothing and then format all the cells as currency.

3. ## Re: DIV/0 error when referencing data from web in separate cell

are they numbers? use =isnumber(H10) and if it returns TRUE then it is but if it returns FALSE then it isn't and you'll have to convert it to a number.

4. ## Re: DIV/0 error when referencing data from web in separate cell

Okay so I ran =isnumber(H10) in a separate cell like Sam Capricci advised and it returned back FALSE. How do I format them as numbers while also making it so when the page refreshes it doesn't just go back to the way it was? Thank you! If you want I can upload the document if this isn't providing enough information.

5. ## Re: DIV/0 error when referencing data from web in separate cell

Came back FALSE. So now I am trying to figure out how to change the formatting while also having it stay that way once I refresh the page. Thank you guys!

6. ## Re: DIV/0 error when referencing data from web in separate cell

you could try this... =AVERAGE(--H10:H18)
that will convert what is in the list to numbers.

7. ## Re: DIV/0 error when referencing data from web in separate cell

You're a lifesaver bro, thank you.

8. ## Re: DIV/0 error when referencing data from web in separate cell

You're welcome. Thanks for the rep.

Note: please include a sample workbook as well as the picture. Takes all the guesswork out of it.

New quick method:

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

There are currently 1 users browsing this thread. (0 members and 1 guests)