With the traditional functions
Formula in cell B10:=(SUM($A$10:A10)+SUM($B$9:B9))*$A$8
=(SUM($A$10:A10)+SUM($B$9:B9))*$A$8