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

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

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

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

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