It works for me if all of D7:DC7 are =0 then you should get 0.

How is it not working... error or wrong value?