I am trying to write a formula using Sumproduct to dived data. I
understand that the reciprocal of a number multiplied is the same as
dividing so Sumproduct shoudl work. the problem is that there are
blanks in the data and then it is diving by one.
=Sumproduct(A1:A5,1/B1:B5) This works fine if there are no 0 or
blanks.

Thanks,
Jay