I get the #div/0! when using the formula =average(d33:d48)

[Glen]

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

 

[IanC]

=IF(SUM(D3348)=0,"",AVERAGE(D3348))

 

[Dave Peterson]

=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.

 

[Vitordf]

Hi,

Or you can use;
=IF(ISERROR(AVERAGE(D3348)),0,AVERAGE(D3348))

Regs,

 

[Dave Peterson]

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(D3348)),"Error",AVERAGE(D3348))

Hi,

Or you can use;
=IF(ISERROR(AVERAGE(D3348)),0,AVERAGE(D3348))

Regs,