Thanks, but unfortunately, I might need that fancy/smancy function.
Sometimes the shipment comes in 6 different orders; ie a sum of 20
ordered parts comes in 5, then 4, then 3, then 5 more, etc. Do you
know of any way to modify my original equation? Thanks.


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=494894