Sumif function
 

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

Sumif function
 

=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

Sumif function
 

Try...

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

Hope this helps!

In article ,
Jack wrote:

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

Sumif function
 

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

"Jack" wrote:

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