Lowest number other than 0

[croyals]

I am tracking mileage on a fleet of 20 buses and am trying to display
the lowest mileage for each bus. I have series of workbooks, each with
20 sheets, with each bus on a seperate sheet. I have 12 workbooks, one
for each month and then a total sheet. I have used the Min function and
spanned each workbook.My problem is the formula returns a value of 0
even though i have no numbers entered so no matter where i put the
mileage it still comes up 0 because that is the lowest number in the
range on another sheet. Any help will be greatly appreciated

 

[Don Guillett]

This formula must be array entered with control+shift+enter instead of just
enter.

=MIN(IF(C4:C14>0,C4:C14))

 

[Peo Sjoblom]

Or entered normally

=SMALL(A1:A5,COUNTIF(A1:A5,0)+1)

--

Regards,

Peo Sjoblom

This formula must be array entered with control+shift+enter instead of just
enter.

=MIN(IF(C4:C14>0,C4:C14))