minimum vales in a row greater than zero

[Araise]

Gents,
har to believe this isn't simple. I want to return a minimum vales in a row that is greater than zero.

A1 A2 A3 A4 A5 A6 A7

0 4 0 3 2 0 6

Is there a way to incorporate an "if" statement into the = Min() statement?
Thanks !!

[AlKey]

Try this array formula

=MIN(IF(A1:A7>0,A1:A7))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Row\Col	A
1	0
2	4
3	0
4	3
5	2
6	0
7	6
8
9	2

[Tony Valko]

Here's another one...

=AGGREGATE(15,6,A1:A7/(A1:A7>0),1)

The equivalent array formula is slightly faster to calculate but the difference is negligible.

[Araise]

Worked like a charm !!!!

[AlKey]

Your' re welcome and thank you for the feedback!