Nesting SUMIF

[Guest]

I need to sum a column but only if 2 criteria are met. criteria is in 2
different columns. I am having problems nesting SUMIF - any suggestions?

 

[Ardus Petus]

Use SUMPRODUCT
=SUMPRODUCT((A1:A999="whatever")*(B1:B999="something");D1999)

HTH

 

[Don Guillett]

try
=sumproduct((a2:a22="joe")*(b2:b22=2)*c2:c22)

 

[Guest]

Try something like this:

=SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2)*C1:C10)

That formula adds values from Col_C where Col_A matches the first criteria
and Col_B matches the second criteria.

Example:
=SUMPRODUCT((A1:A10="active")*(B1:B10="employee")*C1:C10)


Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP