Smallest number greater than zero in range with #num! error

I'm trying to calculate the smallest margins of victory for a fantasy football league.

In a row I have the point difference between a player and their opponent. That number will be either positive (for a win) or negative (for a loss). I am trying to find the 4 smallest positive numbers out of that range (of 17 weeks) for each person.

I have a formula that returns the number, but if brings back a #NUM! error if there aren't at least 4 wins for that person. This creates a problem further down the sheet where I'm trying to calculate the 5 smallest overall margins for the entire league of 10 teams.

Here's the formula I have to return the 4th smallest positive number. The scores are in the range F202:V202. Is there a way of modifying it to give me a blank cell if there isn't a win?

=SMALL(IF($F$202:$V$202>0,$F$202:$V$202, ""),4)

Thanks for your help!
Damian

Dilipandey,

I see it works in your sample, but it doesn't work in mine. I have excel 2003, unfortunately. Is this the reason why it doesn't work in mine? I made sure to type ctrl-alt-enter to put the {} around the formula.

DILIPandey,

I am afraid it still doesn't work. When I paste it in the cell or in the formula bar at the top, it returns the entire formula. Here's a copy of the sheet......


Damian

DILIPandey,

I don't mean to be a pest, but I got it to work for the 4th variable as you have shown, without brackets. I copied and pasted the formula for my 1st, 2nd and 3rd and they show blanks also. I changed the 2 "4"s in the formula to 1, 2 and 3, respectively, but they still show blank.

Hi DILIPandey,

I looked at what you sent back. That works for 1, 2 and 3 now as you say, but the 4th returns a value error...and that is the problem I had from the start.

Damian