| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I get the #div/0! when using the formula =average(d33:d48)
I was wanting to know the formula for this subject so the cell would not show
this error. it comes up when there is no number in the cell. what am I doing wrong. I know there is a formula but can't remember it. thanks -- Glen |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I get the #div/0! when using the formula =average(d33:d48)
=IF(SUM(D33:D48)=0,"",AVERAGE(D33:D48))
-- Ian -- "Glen" wrote in message ... I was wanting to know the formula for this subject so the cell would not show this error. it comes up when there is no number in the cell. what am I doing wrong. I know there is a formula but can't remember it. thanks -- Glen |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I get the #div/0! when using the formula =average(d33:d48)
=if(count(d33:d48)=0,"No Numbers!",average(d33:d48))
I wouldn't check =sum() just because the data sums to 0 doesn't mean that there are no entries in that range. IanC wrote: =IF(SUM(D33:D48)=0,"",AVERAGE(D33:D48)) -- Ian -- "Glen" wrote in message ... I was wanting to know the formula for this subject so the cell would not show this error. it comes up when there is no number in the cell. what am I doing wrong. I know there is a formula but can't remember it. thanks -- Glen -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I get the #div/0! when using the formula =average(d33:d48)
Hi,
Or you can use; =IF(ISERROR(AVERAGE(D33:D48)),0,AVERAGE(D33:D48)) Regs, "Dave Peterson" wrote: =if(count(d33:d48)=0,"No Numbers!",average(d33:d48)) I wouldn't check =sum() just because the data sums to 0 doesn't mean that there are no entries in that range. IanC wrote: =IF(SUM(D33:D48)=0,"",AVERAGE(D33:D48)) -- Ian -- "Glen" wrote in message ... I was wanting to know the formula for this subject so the cell would not show this error. it comes up when there is no number in the cell. what am I doing wrong. I know there is a formula but can't remember it. thanks -- Glen -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I get the #div/0! when using the formula =average(d33:d48)
But if the average could be 0, you wouldn't no if the 0 was caused by the error
or by the sum being 0. If that's important, I'd use: =IF(ISERROR(AVERAGE(D33:D48)),"Error",AVERAGE(D33: D48)) Vitordf wrote: Hi, Or you can use; =IF(ISERROR(AVERAGE(D33:D48)),0,AVERAGE(D33:D48)) Regs, "Dave Peterson" wrote: =if(count(d33:d48)=0,"No Numbers!",average(d33:d48)) I wouldn't check =sum() just because the data sums to 0 doesn't mean that there are no entries in that range. IanC wrote: =IF(SUM(D33:D48)=0,"",AVERAGE(D33:D48)) -- Ian -- "Glen" wrote in message ... I was wanting to know the formula for this subject so the cell would not show this error. it comes up when there is no number in the cell. what am I doing wrong. I know there is a formula but can't remember it. thanks -- Glen -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average formula | Excel Discussion (Misc queries) | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| average in formula? | Excel Discussion (Misc queries) | |||
| Average formula | New Users to Excel | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Hybrid Mode
