Assuming that the formula is used in a single cell, as opposed to be dragged across and/or down, it would seem that you could use:
Formula:
=IF(SUMPRODUCT(((ISNUMBER(1/EG13)+ISNUMBER(SEARCH(SUBSTITUTE(EG13," ",""),REPT("X",10)))>0))*(EG13>0))>0,SUMPRODUCT(((ISNUMBER(1/EG13:FI13)+ISNUMBER(SEARCH(SUBSTITUTE(EG13:FI13," ",""),REPT("X",10)))>0))*(EG13:FI13>0)*(EG9:FI9)*(EG3:FI3)),SUMPRODUCT((((ISNUMBER(1/EG13:FI13)*(EG13:FI13<=0))+(ISNUMBER(SEARCH("x",EG13:FI13))-ISNUMBER(SEARCH(SUBSTITUTE(EG13:FI13," ",""),REPT("X",10)))>0)))*(EG9:FI9)*(EG3:FI3)))
Let us know if you have any questions.
Bookmarks