I am trying to sum a range of cells where two conditions are met. The first cond

Question

I am trying to sum a range of cells where two conditions are met. The first condition is that a range of cells does not equal "BULK". The second condition is that a range of cells equals Food. Here is what I have but there seems to be something missing as the formula sums the range of cells that equals FOOD but does not take the first condition that says do not sum if a range of cells equals "BULK".

=IF(Sales!L:L<>"BULK",SUMIF(Sales!$I:$I,"FOOD",Sales!$P:$P))

Any! help would be greatly appreciatedd!!!.

Thank you,

Explanation / Answer

Try this one.

=SUMIFS(P:P,I:I,"Food",L:L,"<>Bulk")

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects