I entered it like this and now I get a #NUM! error message. Any other
help you can provide?

=SUMPRODUCT('[Account 2005.xls]June'!$A:$A,"<"&TODAY()-120,'[Account
2005.xls]June'!$C:$C)

Thanks again!!!


--
miwarren
------------------------------------------------------------------------
miwarren's Profile: http://www.excelforum.com/member.php...o&userid=24682
View this thread: http://www.excelforum.com/showthread...hreadid=382550