Lowest number other than 0

C

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
 
D

Don Guillett

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

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

Peo Sjoblom

Or entered normally

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

--

Regards,

Peo Sjoblom


Don Guillett said:
This formula must be array entered with control+shift+enter instead of just
enter.

=MIN(IF(C4:C14>0,C4:C14))
Click to expand...
 
Top