sumproduct
 

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

sumproduct
 

=sumproduct(--(a1:a10<""), --(......



anand wrote:

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

--

Dave Peterson