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(H7:DX7<0, H7:DX7,""))
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.

Change your formula in EA7 to this;

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

and copy down to EA22.

Does this solve your problem?

Pete

egarcia wrote:
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(H7:DX7<0, H7:DX7,""))
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.

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

Dave
--
Brevity is the soul of wit.


"egarcia" wrote:

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(H7:DX7<0, H7:DX7,""))
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.