Average Formula - Include zeros

Hello,

i had a previous thread ....which was solved ....

http://www.excelforum.com/excel-prog...e-formula.html


The issue I am having is ...there are certain rows in my WB tht will have a "0.00" value ... when I use this formula:

=AVERAGE(IF((D7:DC7= "Planned")*(D10:DC10),D10:DC10))

I get a DIV/0 error ... how can a resolve this ...

I have tried the following but it doesn't seem to work ...

=IF(SUM(D7:DC7)<>0,AVERAGE(IF((D26:DC26="Planned")*(D7:DC7),D7:DC7)),0)

Thank you in advance.....