software

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 quot;2quot; AND column b
greater than 01/01/2006.

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

Thanks

=SUMPRODUCT(--(A1:A100=2),--(B1:B100gt;=--quot;2006-01-01quot;),C1:C100)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Jackquot; gt; wrote in message
...
gt; I have a problem as following
gt; column A has months as numbers (1 for Jan, 2 for Feb etc)
gt; column b has other set of dates in format mm/dd/yyyy (not related to above
gt; months)
gt; column c has numbers
gt;
gt; I would like to use sumif(or any other function that you recomend) so that
I
gt; would like to have sum of column c which has column a as quot;2quot; AND column b
gt; greater than 01/01/2006.
gt;
gt; I can do them seperately, but I could not figure out with the AND part.
gt;
gt; Thanks
Try...

=SUMPRODUCT(--(A2:A100=2),--(B2:B100gt;quot;2006/1/1quot; 0),C2:C100)

Hope this helps!

In article gt;,
Jack gt; wrote:

gt; I have a problem as following
gt; column A has months as numbers (1 for Jan, 2 for Feb etc)
gt; column b has other set of dates in format mm/dd/yyyy (not related to above
gt; months)
gt; column c has numbers
gt;
gt; I would like to use sumif(or any other function that you recomend) so that I
gt; would like to have sum of column c which has column a as quot;2quot; AND column b
gt; greater than 01/01/2006.
gt;
gt; I can do them seperately, but I could not figure out with the AND part.
gt;
gt; Thanks

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

quot;Jackquot; wrote:

gt; I have a problem as following
gt; column A has months as numbers (1 for Jan, 2 for Feb etc)
gt; column b has other set of dates in format mm/dd/yyyy (not related to above
gt; months)
gt; column c has numbers
gt;
gt; I would like to use sumif(or any other function that you recomend) so that I
gt; would like to have sum of column c which has column a as quot;2quot; AND column b
gt; greater than 01/01/2006.
gt;
gt; I can do them seperately, but I could not figure out with the AND part.
gt;
gt; Thanks