File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Paste Ba Clipboard J6 Calibri BIU 11 Accounting Conditional Formatting Insert - $ - %' Format as Table Delete A 0.00 .00.0 Cell Styles Format Font fx Alignment Number Styles Cells Editing =SUMPRODUCT(C6:E6,F6:H6) B D E F G H Number of Cases 4 Demand San Francisco Empty Los Angeles San Francisco Empty Los Angeles | Shipped Total Cost 5 713 $ 21.81 $ $ 18.02 0 713 713 $ 12,848.26 6 1072 23.31 21.92 1,072 72 #VALUE! 7 363 11.22 15.65 363 0 363 #VALUE! 8 1798 16.82 8.97 0 1,952 1,952 #VALUE! 9 283 10.13 10.02 312 0 312 #VALUE! 10 934 17.35 15.92 934 934 #VALUE! 11 1439 24.06 22.02 1,069 370 1,439 #VALUE! 12 715 14.84 11.12 0 715 715 #VALUE! 13 7,317 0 0 3,750 3,750 #VALUE! 14 15 10.50% 16 17 10 3,550 217 3,550 7,100 3,550 -200 3,350