#DIV/0 error

[Guest]

Trying to average cells which contain formulas with a #DIV/0 error. What can
I do to get the cells with values to average. Here are the formulas.

cell DY7 =AVERAGE(IF(H7X7<>0, H7X7,""))
cell DZ =2
cell EA7=SUM(DY11/DZ11)

when i average EA7:EA22 it is #DIV/0. I have the sheet set up for different
areas with different numbers in each section. I have extra rows in case I
need them and these are the #DIV/0 because there are no values in them.

 

[Pete_UK]

Change your formula in EA7 to this;

=IF(DZ11=0,"",DY11/DZ11)

and copy down to EA22.

Does this solve your problem?

Pete

 

[Guest]

You should suppress errors: =IF(ISERROR([your formula]),"",[your formula])

Dave