Nesting SUMIF

3

360Kid

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?
 
A

Ardus Petus

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

HTH
 
R

Ron Coderre

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
 
Top