#DIV/0! Help!

[JustinD]

Hi,

i know there is countless threads about this error but i really need a
straight up answer,

im just doing a standard average on serveral rows and then i recieve
the #DIV/0! error.

now to my knowledge the rows are set as numeric etc. all we need is a
simple average!

if anyone could help it would be greatfully appreciated

Thanks a tonne,

JD

 

[David Biddulph]

Let's say you're using =AVERAGE(A1:A4), what do you get if you try
=COUNT(A1:A4), because if that gives zero you haven't got numbers. Have you
checked one of the cells with ISNUMBER() ?

 

[JustinD]

Let's say you're using =AVERAGE(A1:A4), what do you get if you try
=COUNT(A1:A4), because if that gives zero you haven't got numbers. Have you
checked one of the cells with ISNUMBER() ?

Hi Thanks for the quick reply,

ive checked the cells and it comes up as a false once is use the
ISNUMBER() forumula?

 

[David Biddulph]

David Biddulph wrote:

Hi Thanks for the quick reply,

ive checked the cells and it comes up as a false once is use the
ISNUMBER() forumula?

So now that you've confirmed that the values are NOT numeric, you can look
at the many threads to which you refer, and which give answers. You'll need
to find what you've got in the cells instead of numbers.