Forum Discussion
#NUM! Error
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
=IFERROR(SMALL(M20:M23,COUNTIF($M$20:$M$23,0)+1),"")
- Thank you. That appears to have fixed it.
