=SUMPRODUCT(--(A1:A100=2),--(B1:B100=--"2006-01-01"),C1:C100)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jack" wrote in message
...
I have a problem as following
column A has months as numbers (1 for Jan, 2 for Feb etc)
column b has other set of dates in format mm/dd/yyyy (not related to above
months)
column c has numbers

I would like to use sumif(or any other function that you recomend) so that
I
would like to have sum of column c which has column a as "2" AND column b
greater than 01/01/2006.

I can do them seperately, but I could not figure out with the AND part.

Thanks