if error with countifs() need to return #N/A

[bloodybrit90]

Hey guys the two formulas below are returning 0 if there is not a value. I have used this formula with median(if()) and average(if()) and it works. Any help will be greatly appreciated.

=IFERROR(COUNT(IF('Both MLS RS'!$BE$33:$BE$10000>='Zipcode Analysis'!$N2,IF('Both MLS RS'!$BE$33:$BE$10000<='Zipcode Analysis'!$O2,IF($A$3='Both MLS RS'!$FH$33:$FH$10000,'Both MLS RS'!$A$33:$A$10000)))),NA())

=IFERROR(COUNTIFS('Both MLS RS'!$BE$33:$BE$10000,">="&$N2,'Both MLS RS'!$BE$33:$BE$10000,"<="&$O2,'Both MLS RS'!$FG$33:$FG$10000,"yes",'Both MLS RS'!$FH$33:$FH$10000,"="&'Zipcode Analysis'!$A$3,'Both MLS RS'!$A$33:$A$10000,">0"),NA())

 

[bloodybrit90]

That worked! Thanks for the Help Barry and Vidar