I'm not sure exactly what your meaning by "until the formula has been
applied" but...
Have you tried the SUMIF function?
Look it up in Help for examples of its useage.
Hope this helps...
--
S3NTYN3L
------------------------------------------------------------------------
S3NTYN3L's Profile:
http://www.excelforum.com/member.php...o&userid=30247
View this thread:
http://www.excelforum.com/showthread...hreadid=505447