SUMIF Question

C

cincode5

Hello,

Is it possible to use SUMIF with multiple conditions. I have three product catagories in a column, and need a subtotal the dollar value of each catagory based upon its A) its product code, and B) its active (or inactive) status.

Regards...
 
L

Leah

You can do this with a matrix -- install the add in for the Conditional SUM Wizard and it should walk you right through it. Do this with Tool Addin and select Conditional sum wizard. (You may need your office disk available).

Leah
 
N

Norman Harker

Hi Cincode5!

You shoulD be able to do this with SUMPRODUCT:

EG

=SUMPRODUCT(--($A$1:$A$8="#1204"),--($B$1:$B$8="Active"),($C$1:$C$8))

The -- coerce Boolean responses to 1 for TRUE and 0 for FALSE.
--
 
Top