iserror formula help please

[chrissavvy]

I have an array formula that looks at a column of 48 percentages to see what percentage of the numbers are between -5% and 5%. Some of the data in the columns are #DIV/0 so my formula reports back as #DIV/0.

How can I incorporate the 'iserror' formula into this so I still get a result from the formula?

Here is the formula:

{=SUM(IF(R3:R50<=5%,IF(R3:R50>=-5%,1,0),0))/48}

Any help would be appreciated.

 

[just_jon]

Wouldn't it be a better idea to not get the DIV0's to begin with? That formula should be easily fixed.