There are several ways to do this. Here's one:

Try this array formula**:

=MIN(IF(A1:A100<0,A1:A100))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

"pdeaston" wrote in message
...
I have a spreadsheet where I track maximum and minimum values. The data is
entered daily, so I have formulas entered for the entire year. That
means,
of course, that zero is the value for every day of the year beyond today.
How do I omit those in my calculation of minimum values?