Removing #N/A Entries From Long Formula

Hey Everyone,

New here with a question that hopefully some of you Excel wizards can help me with. I hope I posted this in the right place.

I'm attempting to remove the #N/A entries left from my formula when cells in the array are blank.

Here is the formula I've pieced together that does just about everything I need except display " " instead of #N/A when there is nothing present in the array of cells.

{=IFERROR(INDEX(I11:BP11,MODE(IF(ISTEXT(I11:BP11),MATCH(I11:BP11,I11:BP11,0)))),LOOKUP("istext",I11:BP11))}

Originally I had " " entered where the lookup string is located. I added the lookup because it was ignoring single entries as you can't get the mode or average of 1.

Could some one help me find a spot where I can tell the formula to display a blank space instead of #N/A?

Thanks for any assistance.