The following formula works fine when all "B" cells have a
value 0. When a "B" cell is zero, the formula returns
#Value!. Is it possible to modify this formula so that it
ignores the zero value and sums the other "B" products?

=(SUM(PRODUCT(BI35,BI37),PRODUCT(BI38,BI40),PRODUC T
(BI41,BI43)))*AR44

Thanks,
Phil