Hello,

Is there a way to use a sumproduct formula looking at non-contiguous cells?

In cell a1, I have this formula:

=SUMPRODUCT((G14<G15)*(H14G15)*(LEN(G14)0))+SUMP RODUCT((G16<G15)*(H16G15)
*(LEN(G16)0))

I tried the following with no success:

SUMPRODUCT(((G14,G16)<G15)*((H14,H16)G15)*(LEN((G 14,G16))0), but gives me
a #VALUE

Any suggestions?

Thanks

André