thks McG!

i am able to get the result..but Bob's function seems to be elegant..!

regds!

-via135




On Feb 8, 10:20 pm, JE McGimpsey wrote:
One way:

=SUMPRODUCT(--(A1:A11=DATE(2006,1,1)), --(A1:A11<=DATE(2006,4,1)),
-((B1:B11=2)+(B1:B11=4)-1), C1:C11)

In article . com,



"via135" wrote:
hi!

i'm having the following data thru A1:C11
what i want is the sum of amt between a
given period but not equal to some codes!

for example

the sum of amt for the period 01/01/2006 to 01/04/2006
(inclusive of both dates) for the codes not euqal to 2 & 4
ie. the result should be 140..!

date code amt
01/01/2006 1 10
01/01/2006 3 20
02/02/2006 4 30
03/03/2006 1 50
30/03/2006 3 60
01/04/2006 2 40
02/05/2006 2 30
02/05/2006 4 20
01/07/2006 1 10
04/07/2006 2 50

help pl.?!

regds!

-via135- Hide quoted text -

- Show quoted text -