Need to ignore text entered in range for formula

Hello Function Guru's:
Have this formula. At some time in it's usage, a user might enter some text in a cell in the source data range, resulting a #VALUE error, and hosing the entire summary table. Is there a way to modify the formula to ignore any text present in a cell contained inthe source data table?

{=IF(AB7="","",MIN(IF(($G$2:$Z$2=AD$5)*($A$5:$A$999=$AB7)*($G$5:$Z$999)<>0,($G$2:$Z$2=AD$5)*($A$5:$A$999=$AB7)*($G$5:$Z$999))))}

(cannot upload a working copy.)

Thanks for any input.

Pete

Perhaps

=IF(AB7="","",MIN(IF(ISNUMBER($G$5:$Z$999),IF(($G$2:$Z$2=AD$5)*($A$5:$A$999=$AB7)*($G$5:$Z$999)<>0,($G$2:$Z$2=AD$5)*($A$5:$A$999=$AB7)*($G$5:$Z$999)))))

Although I agree with Speshul
You'd be better off preventing the invalid entry in the first place.

Hiding or working around the error isn't always the best thing.
You will probably be getting a wrong answer from the formula, and not knowing it.
The Error value let's you know that something is wrong.

In my opinion, it's the 'expected' errors that are ok to trap and hide.
I want to see the UN-Expected errors..

Jonmo, that was amazing. Thank you. Thank you speshul, as well.

Pete

You're welcome.