#DIV/0 error
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.
|