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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!
>
>