Min/Max to ignore error values

[Graham Tritton]

I have a series that contains #N/A errors results from a formula. I want to
calculate the min/max of the actuals values ignoring the error values. Any
ideas? I have tried min() & mina() but returning errors.

 

[RagDyer]

It's always advisable to correct the error in the original formula.

Why not post the formula that's returning the error so that a suggestion can
be made to eliminate it.

If you insist on keeping the errors visible in the range, you can try
something like this *array* formula:

=MIN(IF(NOT(ISNA(A1:A5)),A1:A5))

 

[Dave Peterson]

Another:

=if(count(a1:a10)=0,"No numbers",min(if(isnumber(a1:a10),a1:a10)))

Still array-entered.