I am trying to create a formula that finds the minimum cellin a range, as long as one cell has a value (excludes zeros), then looks to another cell if all others in the MIN range are zeros.

I currently have this which finds the minumum but excludes zeros 


What I think I need but it doesn’t work is this:


Any help would be greatly appreciated


By: Wylie

Leave a Reply

Your email address will not be published. Required fields are marked *