Thank you for the formula. I guess I was on the right track as I thought it
was probably a sumproduct.

I will enter into the spreadsheet in the morning back at work.

In the formula I notice in several areas you have a -- is that correct?


"rsenn" wrote in
message ...

For the first formula use.

=sum(R20:r50) - sumproduct((--(r20:r50<c2),--(r20:r50)) -
sumproduduct((--r20:r50d2),(r20:r50))

For the 2nd and 3rd formulas, substitute c3 and c4 for c2, and d3 and
d4 for d2.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile:
http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=493231