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 -
but it is returning #value. If we delete all dashed cell, then it returns only. How to make a round about.