If Cell Blank don't Count but if array >= Cell then count

[Barbz]

Hi All, I currently have a top X formula going on.
I142 is whatever number I want to put in, for example 10.
I143: =IFERROR(LARGE($N$2:$N$126, $I142),"0")
I144: =IFERROR(COUNTIF($N$2:$N126,">="&$I143)," ")

I would like to change I144 so that when it looks at I143 and it is zero (based on the formula in 142) then it either does not perform the count or displays as blank or zero (if that is easier).

Essentially, if we don't have a top x and i142 is blank or zero (again I'm good with either) then I don't want to see anything in I144.

I hope that makes sense, and I really appreciate the help.

 

[Scott Huish]

A couple things I would like to point out. You shouldn't put the 0 in quotes, that makes it text. You should also return "" not " " to return blank, otherwise it returns a space.

I143: =IFERROR(LARGE($N$2:$N$126,$I142),0)
I144: =IF(I143=0,"",COUNTIF($N2:$N126,">="&$I143))

 

[Barbz]

Thanks so much Scott. I'm obviously a bit of a beginner when it comes to properly understanding formulas. I really appreciate the formulas and the info. It helps a great deal. Thanks again!