sumproduct

A

anand

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
 
D

Dave Peterson

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


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
Click to expand...
 
Top