=SUMPRODUCT(--(A2:A20=--"2006-01-01"),--(*A2:A20<=--"2006-04-01"),--(NOT(IS
NUMBER(MATCH(B2:B20,{2,4},0)))),C2:C20)

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"via135" wrote in message
ups.com...
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