Averaging columns

G

GarrettSocling

I tried Average, but it won't pass over the broken references either.
Since I have these columns present with no data, I have a divide b
zero error...I need the average to just ignore those columns.

I am a n00b when it comes to Excel, so forgive me if I am overlookin
something simple...

Thanks,
Garret
 
F

Frank Kabel

Hi
you may change your formulas which create the #DIV error. post your
used formulas which create an error
 
Top