Nesting SUMIF
 

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?

Nesting SUMIF
 

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

HTH
--
AP

"360Kid" a écrit dans le message de news:
...
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?

Nesting SUMIF
 

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

--
Don Guillett
SalesAid Software

"360Kid" wrote in message
...
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?

Nesting SUMIF
 

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


"360Kid" wrote:

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?