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 :D

Thanks a tonne,

JD

Good evening JustinD
Use Insert Function Average, Select Range and Click Insert Function, Average
that should do it

"JustinD" wrote:

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 :D

Thanks a tonne,

JD

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() ?
--
David Biddulph

"JustinD" wrote in message
oups.com...
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 :D

Thanks a tonne,

JD

David Biddulph wrote:
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() ?
--
David Biddulph

"JustinD" wrote in message
oups.com...
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 :D

Thanks a tonne,

JD


Hi Thanks for the quick reply,

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

"JustinD" wrote in message
ups.com...

David Biddulph wrote:

"JustinD" wrote in message
oups.com...
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 :D

Thanks a tonne,

JD

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?

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.
--
David Biddulph