SUMIF Question

G

Guest

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...
 
G

Guest

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.
--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering with SUMIFS 1
sumproduct or sumif? 3
SUMIF with multiple conditions 5
Sumif question 2
how many items for a catagory have been sold 3
How to Count the number of "rows" (or Array items) included in a Sumif formula? 3
Lessons from optimizing a slow spreadsheet 2
SUMIF function formula won't work, help 6

Top