Can anyone tell me how to indicate a "non-blank" in a sumproduct function?

I'm workikng with an array that has many blank spots and are being read as
zero for a function that requires all actual values between -5 and +5.

Thanks

anand