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.

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.

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

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.





If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
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.