Resolving #VALUE error in spreadsheet

Table 1, Column B has an index-match formula, whereby the results will either be no value or AU######

I need a formula for Column I using the following criteria:
If Column B is blank, then sum Col C, Col E, Col G
If Column B = AU######, then sum Col C, Col D, Col E, Col F, Col G, Col H

Note:
Columns B to Column H contain index-match formulas.

In attempting the formula myself, I was receiving the #VALUE error message in Column I, which I realized was because some of the cells do not have values. I understand that using SUMIF may be the solution in dealing with this scenario...?

I have included an example spreadsheet.

Thanks!
Andrea
Resolving-VALUE-Error_EE.xlsm