Dear Experts,

I am having some values in column A1:A10 with some cell having - (dash). Correspondingly column B1:B10 is also having some values with - related to - in column. To calculate sumproduct of both the columns leaving dashed cell, i type following array formula -

=if(isnumber(A1:A10),sumproduct(A1:A10*B1:B10),"-")
but it is returning #value. If we delete all dashed cell, then it returns only. How to make a round about.

Regards,

Dastgir