If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#DIV/0! Help!
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 |
#2
|
|||
|
|||
#DIV/0! Help!
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 Thanks a tonne, JD |
#3
|
|||
|
|||
#DIV/0! Help!
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 Thanks a tonne, JD |
#4
|
|||
|
|||
#DIV/0! Help!
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 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? |
#5
|
|||
|
|||
#DIV/0! Help!
"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 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 |
Thread Tools | |
Display Modes | |
|
|