How put "> or <" a variable into multiconditional SUMIFS

[somanyqs]

Picking up on an old thread (apologies if I was supposed to just tack onto the old one)

Trying to find sum of the values in Column A for a March sale (indicated in Column B) if the cell in Column C is >0 OR the cell in Column D is >0, and Column E is >10.

I think it would be something like this...
=SUM(SUMIFS(A:A,B:B,"="&"March",OR(C:C,">"&0,D:D,">"&0),E:E,">"&10))

Though I don't think I am handling the "OR" correctly.

Thanks everyone-

 

[AAE]

You don't need to use SUM(SUMIFS)), just use the SUMIFS

=SUMIFS(B1:B100,"March",C1:C100,">0",D1:D100,">0"), etc.

See the Excel Help to understand the syntax and arguments

 

[somanyqs]

Doesn't the above create an "AND", so the function is C>0 AND D>0?
(rather than C>0 or D>0)?
Thanks -

 

[Jonmo1]

Doesn't the above create an "AND", so the function is C>0 AND D>0?
(rather than C>0 or D>0)?
Thanks -

You are correct..
Doing OR conditional counts/sums is tricky.

I would recommend using a helper column to do the or, then use that column in the SUMIF
Say in column F put =OR(C1>0,D1>0) and fill down
Then use

=SUMIFS(A:A,B:B,"March",F:F,TRUE,E:E,">"&10))

 

[somanyqs]

Ahh, just what I did. I was thinking there might be something more elegant than my workaround
Did the same for the MEDIAN(IF) and AVERAGEIFS

Thanks for confirming my decision! Much appreciated-