Does this work for you?

=SUMPRODUCT(--('Unit 1'!A2:A500<=TODAY()-1),--('Unit 1'!B2:B500))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ledzepe" wrote in
message ...

Oh... each unit have their own sheet, example unit 1 is identified as
sheet "Unit1", and so on...


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile:
http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=495556