David Billigmeier wrote...
Add a check to the beginning of your function. Enter the following with
CTRL+SHIFT+ENTER now, as it is an array function:

=IF(AND(D51:H51=""),"",SMALL(D51:H51,COUNTIF(D51: H51,"<=0")+1))
....

Could still fubar if there were text in the range but no numbers. SMALL
(and LARGE) return #NUM! errors when there are fewer numbers in the
range or array given as first argument than the positive integer given
as second argument, so the proper error trap should be ensuring there's
at least one positive number in the range. Myself, I'd use

=IF(COUNTIF(rng,"0"),LARGE(rng,COUNTIF(rng,"0")) ,"")