Sumif function

[Guest]

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Domenic]

Try...

=SUMPRODUCT(--(A2:A100=2),--(B2:B100>"2006/1/1"+0),C2:C100)

Hope this helps!

 

[Guest]

You can use the sumproduct function to effect a sumif with multiple criteria:
=sumproduct(--(a$1:a$10000=2),--(b$1:b$10000>date(2006,1,1)),c$1:c$10000))