| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i get an average with #div/0! in a cell
I am looking to get an average from like c9:l9. Those cells are linked to
other worksheet averages. They sometime have #div/0! in it. I am loooking to ignore that part and just get the average of numbers in those cells. Any help would be appreciated regards, BK |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i get an average with #div/0! in a cell
Hi!
You should make an attempt at correcting the errors then you won't have to mess around dealing with them! Try this: Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just ENTER): =AVERAGE(IF(ISNUMBER(C9:C19),C9:C19)) Biff "bk_412" wrote in message ... I am looking to get an average from like c9:l9. Those cells are linked to other worksheet averages. They sometime have #div/0! in it. I am loooking to ignore that part and just get the average of numbers in those cells. Any help would be appreciated regards, BK |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i get an average with #div/0! in a cell
=AVERAGE(IF(ISERROR(A1:A100),"",A1:A100))
ctrl+shift+enter (not just enter) "bk_412" wrote: I am looking to get an average from like c9:l9. Those cells are linked to other worksheet averages. They sometime have #div/0! in it. I am loooking to ignore that part and just get the average of numbers in those cells. Any help would be appreciated regards, BK |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i get an average with #div/0! in a cell
That will fail if there are empty cells in the range.
Biff "Teethless mama" wrote in message ... =AVERAGE(IF(ISERROR(A1:A100),"",A1:A100)) ctrl+shift+enter (not just enter) "bk_412" wrote: I am looking to get an average from like c9:l9. Those cells are linked to other worksheet averages. They sometime have #div/0! in it. I am loooking to ignore that part and just get the average of numbers in those cells. Any help would be appreciated regards, BK |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i get an average with #div/0! in a cell
Hi Biff,
That worked GREAT!! :) Thanks I really appreciate it. BK "Biff" wrote: Hi! You should make an attempt at correcting the errors then you won't have to mess around dealing with them! Try this: Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just ENTER): =AVERAGE(IF(ISNUMBER(C9:C19),C9:C19)) Biff "bk_412" wrote in message ... I am looking to get an average from like c9:l9. Those cells are linked to other worksheet averages. They sometime have #div/0! in it. I am loooking to ignore that part and just get the average of numbers in those cells. Any help would be appreciated regards, BK |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i get an average with #div/0! in a cell
You're welcome. Thanks for the feedback!
Biff "bk_412" wrote in message ... Hi Biff, That worked GREAT!! :) Thanks I really appreciate it. BK "Biff" wrote: Hi! You should make an attempt at correcting the errors then you won't have to mess around dealing with them! Try this: Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just ENTER): =AVERAGE(IF(ISNUMBER(C9:C19),C9:C19)) Biff "bk_412" wrote in message ... I am looking to get an average from like c9:l9. Those cells are linked to other worksheet averages. They sometime have #div/0! in it. I am loooking to ignore that part and just get the average of numbers in those cells. Any help would be appreciated regards, BK |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i get an average with #div/0! in a cell
Agree with you biff, that is nice to get a feed back from people that you help.
Happends to ofen that you dont get a feedback. Best regards Pb Biff skrev: You're welcome. Thanks for the feedback! Biff "bk_412" wrote in message ... Hi Biff, That worked GREAT!! :) Thanks I really appreciate it. BK "Biff" wrote: Hi! You should make an attempt at correcting the errors then you won't have to mess around dealing with them! Try this: Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just ENTER): =AVERAGE(IF(ISNUMBER(C9:C19),C9:C19)) Biff "bk_412" wrote in message ... I am looking to get an average from like c9:l9. Those cells are linked to other worksheet averages. They sometime have #div/0! in it. I am loooking to ignore that part and just get the average of numbers in those cells. Any help would be appreciated regards, BK |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i get an average with #div/0! in a cell
I like to know if what I suggested did or did not work.
Biff "Fingerjob" wrote in message ... Agree with you biff, that is nice to get a feed back from people that you help. Happends to ofen that you dont get a feedback. Best regards Pb Biff skrev: You're welcome. Thanks for the feedback! Biff "bk_412" wrote in message ... Hi Biff, That worked GREAT!! :) Thanks I really appreciate it. BK "Biff" wrote: Hi! You should make an attempt at correcting the errors then you won't have to mess around dealing with them! Try this: Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just ENTER): =AVERAGE(IF(ISNUMBER(C9:C19),C9:C19)) Biff "bk_412" wrote in message ... I am looking to get an average from like c9:l9. Those cells are linked to other worksheet averages. They sometime have #div/0! in it. I am loooking to ignore that part and just get the average of numbers in those cells. Any help would be appreciated regards, BK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell References | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| eliminating the 0 in DIV/0 | Excel Discussion (Misc queries) | |||
| average every 6th cell in a column | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
