Conditional Sum

[Gos-C]

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 an
third characters being letters and the remainding characters bein
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 recor
number sum the dollar value in Column L.

Any help

 

[Myrna Larson]

See if this works:

=SUMPRODUCT(--(MID(A9:A933500,2,2)="LR"),--(B9:B33500>DATE(2003,12,31)),(L9:L33500))