Sorry, clumsiness. SUMPRODUCT only works on part of a column, not the whole
column, so try

=SUMPRODUCT('[Account
2005.xls]June'!$A1:$A1000,"<"&TODAY()-120,'[Account2005.xls]June'!$C1:$C1000
)

or howver many rows that you have.


--
HTH

Bob Phillips

"miwarren" wrote in
message ...

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