how to return a result from 2 conditions?
 

From the information below, I'm need a formula that when
the column A1:A3 = 6/27/07 AND column C1:C3 = in, then count column B1:B3

date count in/ot/dd
6/27/07 10 in
6/30/07 1 dd
7/6/07 9 ot

In this example above the correct result would be 10 but I can't get a
formula to consider 2 conditions. (Excel 2003) Thanks.

how to return a result from 2 conditions?
 

Try this:

=SUMPRODUCT(--(A1:A3=DATE(2007,6,27)),--(C1:C3="in"),B1:B3)

HTH,
Elkar


"Christy" wrote:

From the information below, I'm need a formula that when
the column A1:A3 = 6/27/07 AND column C1:C3 = in, then count column B1:B3

date count in/ot/dd
6/27/07 10 in
6/30/07 1 dd
7/6/07 9 ot

In this example above the correct result would be 10 but I can't get a
formula to consider 2 conditions. (Excel 2003) Thanks.

how to return a result from 2 conditions?
 

It works! Thanks so much.

"Elkar" wrote:

Try this:

=SUMPRODUCT(--(A1:A3=DATE(2007,6,27)),--(C1:C3="in"),B1:B3)

HTH,
Elkar


"Christy" wrote:

From the information below, I'm need a formula that when
the column A1:A3 = 6/27/07 AND column C1:C3 = in, then count column B1:B3

date count in/ot/dd
6/27/07 10 in
6/30/07 1 dd
7/6/07 9 ot

In this example above the correct result would be 10 but I can't get a
formula to consider 2 conditions. (Excel 2003) Thanks.