Remember Me?

#1
October 27th 04, 10:21 PM
 Gos-C Posts: n/a
Conditional Sum

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

#2
October 27th 04, 11:20 PM
 Myrna Larson Posts: n/a

See if this works:

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

On Wed, 27 Oct 2004 16:21:42 -0500, Gos-C
wrote:

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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post LDanix Excel Discussion (Misc queries) 1 January 13th 05 06:50 PM Nicolle K. Excel Discussion (Misc queries) 2 January 7th 05 01:08 AM BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM Dana Zulager Excel Discussion (Misc queries) 7 December 7th 04 11:02 PM David McRitchie Excel Discussion (Misc queries) 1 November 27th 04 06:03 PM

All times are GMT +1. The time now is 08:38 AM.