SUMIF w/multiple conditions

L

lightstation67

Here's my current formula:

=SUMIF(A3:A50,"Consumer",J3:J50)/C55

This works fine to get an average sum for everything that reads Consumer,
but now I need to sum only the positive $ amounts in column "J3:J50". How and
where do I insert this extra condition?

Any help would be appreciate. Thanks
 
E

Eduardo

Hi,
Try

=sumproduct(--(a3:a50="Consumer"),--(J3:J50>0),J3:j50/c55)

If this helped please click yes, thanks
 
J

JEB

Now, what if I need to sum only the amounts in column "J3:J50" where there
is no "#Value" displayed.
 
F

Fred Smith

Fix the cells which are displaying #Value. Typically done with:
=if(iserror(yourcalculation),0,yourcalculation)

Regards,
Fred
 

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

SUMIF with multiple conditions 5
sumproduct problem 2
Can I have two conditions in a SUMIF? 5
Conditional Add Formula 1
Sum with multiple conditions 1
Sumif with multiple conditions 3
Sumif with named range of nonadjacent cells. 6
adding multiple values from matched search results 3

Top