Try...

=SUMPRODUCT(--('[Account
2005.xls]June'!$A$2:$A$65536<TOTAY()-120),'[Account
2005.xls]June'!$C$2:$C$65536)

Note that SUMPRODUCT does not allow whole column references. But you
can use 'near' whole column references, as per above formula.

Hope this helps!

miwarren Wrote:
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!!!


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