Hi,
I want to apply sumproduct on mixed text & numbers arrays, expecting result
only when valid multipluy occurs

{1,a,3,1,b},{2,2,1,c,1}={4}