Average Formula - Include zeros

Originally Posted by daddylonglegs

Try

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

This gave me a "#VALUE" error....