Find the Min from two SUMIFs - Ignore Zero's

[CodyMonster]

I'm trying to figure out how to get the minimum value from two sumifs while ignoring zeros and negative values.
I've been trying to work this out with nested IFs.. and I'm not getting very far.
For example:
Sumif #1: 5
Sumif #2: 0
Returns 5

However
Sumif #1: 5
Sumif #2: 2
Returns 2

Additionally,
Sumif #1: 5
Sumif #2: -2
Returns 5

Hope this makes sense?

 

[SullyWYO]

This will work:

=MIN(IF(D3<=0,1E+99,D3),IF(D4<=0,1E+99,D4))

In English, it is asking for the minimum of D3 or D4, as long as that number is greater than 0. If the number is less than zero, it converts the number to infinity so it won't ever be the minimum. (1E+99 is a substitution for infinity).

**I just edited this post to make the formula "<= 0" instead of "=0". I misread the original parameters** Code above should be correct.

 

[CodyMonster]

This will work:

=MIN(IF(D3<=0,1E+99,D3),IF(D4<=0,1E+99,D4))

In English, it is asking for the minimum of D3 or D4, as long as that number is greater than 0. If the number is less than zero, it converts the number to infinity so it won't ever be the minimum. (1E+99 is a substitution for infinity).

**I just edited this post to make the formula "<= 0" instead of "=0". I misread the original parameters** Code above should be correct.

View attachment 74080

Got it to work..
Thanks... I would have never thought of the 1E+99 as infinity.
It's funny how all my questions, at the end of the day, aren't that complicated.
But I'm good at making it complicated.