Hello all. Is it possible to have a 2-column sumif? Columns A & B
have crieteria in them. Column C has the data to be summed.
Essentially, sum the fields in column C if the criteria in BOTH column
A & B are met.

For example, Column A has hire date. Column B is employee status (Y
or N). Can I have a sumif for all employees hired after 1/1/2006 AND
employee status of Y?

Thanks!

=SUMPRODUCT(--(A2:A200=--"2006-01-01"),--(B2:B200="Y"),C2:200)

SP doesn't work with whole columns pre Excel 2007

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Steve" wrote in message
ups.com...
Hello all. Is it possible to have a 2-column sumif? Columns A & B
have crieteria in them. Column C has the data to be summed.
Essentially, sum the fields in column C if the criteria in BOTH column
A & B are met.

For example, Column A has hire date. Column B is employee status (Y
or N). Can I have a sumif for all employees hired after 1/1/2006 AND
employee status of Y?

Thanks!

Take a look at SumProduct...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"Steve" wrote:

Hello all. Is it possible to have a 2-column sumif? Columns A & B
have crieteria in them. Column C has the data to be summed.
Essentially, sum the fields in column C if the criteria in BOTH column
A & B are met.

For example, Column A has hire date. Column B is employee status (Y
or N). Can I have a sumif for all employees hired after 1/1/2006 AND
employee status of Y?

Thanks!