Min - If function with multiple conditions results in Zero

Please see attached excel where I am trying to calculate the Minimum number in Column A, where the rows match multiple conditions.

I am getting a zero as a result whereas the expected result should be from Cell A15

Appreciate any Help.

Give this try

Formula:

=MIN(IF(($B$2:$B$25=B16)*($C$2:$C$25="Arrive")*(A2:A25>0),$A$2:$A$25))

...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.

I dont have any Zero data in Column A, in that case I hope I can avoid *(A2:A25>0) this part from the function.

Please correct me if I am wrong.

AND could you please tell me why it was not working with the AND condition, as I was under the impression "AND" & * refer to the same logic in Excel.

Absolutely correct you can, I just added to avoid if there is any cell having 0 value.