André,
Not sure why you need to shorten it, but is this any good (not the way you
were thinking)
=((G14<G15)*(H14G15)*(LEN(G14)0))+((G16<G15)*(H1 6G15)*(LEN(G16)0))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Andre Croteau" wrote in message
...
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é
|