I entered:
=SUMPRODUCT((REPLACE(REPLACE(A9:A933500,1,1,""),3, 4,"")="LR"),(B9:B33500"31-Dec-03"+0),(L9:L33500))
Column A contains eight-character record numbers with the second and
third characters being letters and the remainding characters being
numbers. Column B contains dates. Column L has dollar values.
If Column B is greater than 31-Dec-2003 and Column A is an LR record
number sum the dollar value in Column L.
Any help?
--
Gos-C
------------------------------------------------------------------------
Gos-C's Profile:
http://www.excelforum.com/member.php...o&userid=14518
View this thread:
http://www.excelforum.com/showthread...hreadid=272991