Try this formula instead:
=MIN(IF('This week'!C140:C211<0,'This week'!C140:C211))
But note that this is an array formula, so you need to press
CTRL+SHIFT+ENTER rather than just ENTER when you put the formula in and
whenever you edit it.

"dartanion" wrote in message
...
Excel tells me there is an error in the middle of the formula and
highlights
C211,COUNTIF

"Mike H" wrote:

Maybe

=SMALL('This week'!C140:C211,COUNTIF('This week'!C140:C211,0)+1)

Mike

"dartanion" wrote:

In part of a row of data, I need the minimum number, but I must exclude
zeros.
The zeros have to remain in place for other reasons. (the use is for
golf
scores, and I am seeking the best score ever for individuals who all
have
their own column of data, but have zeros when they did not play) So I
have=MIN('THIS WEEK'!C140:C211), but that formula returns zero when one
or
more of those cells are a zero