Hi,

From what I understand, the function sumproduct() would do the job ...
Should you provide more details, with an example of what appears in A10
and B10, problem could be quickly solved.

HTH
Cheers
Carim