Removing a #value! and replacing with a 0

[Stretlow]

I have this doing exactly what I want

=SUMPRODUCT((C2:C1000="PA_SECURE_CODE")*(D2:D1000))

But when there is no results it displays

#value!

Can someone please advise me on how to get it to display 0 (zero) instead.


Thanks In advance

Stret

 

[mikerickson]

try
=SUMPRODUCT((C2:C1000="PA_SECURE_CODE")*N(D2:D1000))

 

[Stretlow]

try
=SUMPRODUCT((C2:C1000="PA_SECURE_CODE")*N(D2:D1000))

Thanks for your swift response, Much appreciated


Stret