Yes, the double minus signs tease the interim evaluated results in the
formula into a number.
I think I had a typo in the original formula, but you probably caught
it.
=sum(R20:r50) - sumproduct((--(r20:r50<c2),--(r20:r50)) -
sumproduduct(--(r20:r50d2),(r20:r50))
--
rsenn
------------------------------------------------------------------------
rsenn's Profile:
http://www.excelforum.com/member.php...o&userid=29050
View this thread:
http://www.excelforum.com/showthread...hreadid=493231