Find lowest number in a row in a range of columns

[jaxs2009]

Running Excel 2016, in 2011 a good gentleman helped me with a formula here in Mr Excel in which I have lost, here is what I am needing to do again.

In cell A11, I need a formula that will find the lowest number in a range of columns lets say G11:P11, trick is if all cells in that row between the column range G11:P11 is formatted to accounting and reflecting no entry as I enter a number in each of the cells in that row between the column range I only want cell A11 to reflect the lowest entered number entered. If a cell has no entry then the formula needs ignore no entry cell(s) and find the lowest number.

Thank you to anyone who can help me, Jaxs2009

 

[barry houdini]

....a good gentleman helped me with a formula here in Mr Excel in which I have lost...

Was it this answer?

 

[jaxs2009]

That is what i am asking for, help an answer/formula

 

[crazydragon84]

=minifs(range, <>"")

 

[jaxs2009]

This formula give me an error message that I need to type an apostrophe first

 

[crazydragon84]

My mistake. =MINIFS(G11:P11,G11:P11,"<>")

 

[MARK858]

@ jaxs2009, I take it you did realise that the orange text "this answer" in Barry's post (post number 2) is a link to your original post and so the answer that you received then?

 

[jaxs2009]

I did not know that the orange text "this answer" thanks for letting know, its been since 2011 I was on Mr. Excel.

 

[jaxs2009]

This formula for cell A11 will find the lowest number in column range G11:P11 if there is a number in each of the cells on row 11 in column range G11:P11 as soon as there is no entry in anyone of the cells then A11 refelct zero/nothing.

 

[crazydragon84]

Then the formula that was in the link Barry gave works (in fact the submitter was you on that thread)