Compound Sumif

[Steve]

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!

 

[Bob Phillips]

=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)

 

[Guest]

Take a look at SumProduct...

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