#NUM! Error

New Contributor

I need to see how to "fix" the #NUM! error on my spreadsheet.

Once data is entered in the cells it refers to the results are correct.  The formula is:

=SMALL(M20:M23,COUNTIF($M$20:$M$23,0)+1)

 

2 Replies

@Mike_Lincecum 

=IFERROR(SMALL(M20:M23,COUNTIF($M$20:$M$23,0)+1),"")

Thank you. That appears to have fixed it.