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

G

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
 
D

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

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(D33:D48)),"Error",AVERAGE(D33:D48))
Hi,

Or you can use;
=IF(ISERROR(AVERAGE(D33:D48)),0,AVERAGE(D33:D48))

Regs,
Click to expand...
 
Top